Purchase Solution

Creating an Access Database

Not what you're looking for?

Ask Custom Question

Chris and Pat Aquino own a successful ISP (Internet Service Provider) and want to expand their business to host an Internet auction site. The auction site will let sellers offer items for sale, such as antiques, first-edition books, vintage dolls, coins, art, stamps, glass bottles, autographs, and sports memorabilia. After a seller posts an item for sale, it is sold at the auction site by accepting bids from buyers. Before people can sell items and bid on items, they must register with the auction site. Each item will be listed by subcategory within a general category, making it easy for bidders to find items of interest to them. For example, the general category of antiques might consist of several subcategories, including ancient world, musical instruments, and general.
Chris and Pat have registered their Web site name of each, which stands for electronic Auction Collectibles Host. Now they need to create a database that keeps track of the registered people, the items for sale, and the bids received for those items by the Web site. Chris and Pat Aquino want you to create a user-friendly interface for the BuySell database. They ask you to create a switchboard for the BuySell database by completing the following:
1. Start Access, and then open the BuySell database located in the LE5 folder extracted from the zip file in IP3.
2. Design and create a switchboard form named Switchboard. Use the figure below and the following descriptions as a guide in designing the switchboard.
o Create a macro group named Switchboard Macros for the command buttons. The command buttons perform these actions: open the Subcategory table, open the Item form, open the Registrant form, open the Projected Income Based on Minimum Bid report in the Print Preview window, and close the switchboard and activate the Database window. Define the hot keys for each command button.
o Create the switchboard and place the command buttons on the form.
o Specify "BuySell" as the name to appear in the title bar. Delete the default label in the form and place a label at the top of the switchboard. The label should read "electronic Auction Collectibles Host" and should be in italics and boldface with a 16-point font size.
o Set the background color for the switchboard, as shown in figure above, and then set form properties that are appropriate for a switchboard.
3. Save the Switchboard form, and then test the command button to make sure that your switchboard items work correctly. If necessary, return to the Switchboard Manager and make any corrections.
4. Click the Exit to BuySell command button to close the Switchboard form.
5. Modify the Item form to display the message "Very High Reserve" to the right of the ReservePrice field-value text box. Use the ForeColor value of blue, and make the font bold. Display the message only when the ReservePrice field value is greater than 1000. Test the modified form, and then save and close it.
6. Set the database password to "password" (no quotes).
7. Use the Database Splitter Wizard to split the BuySell database. Use the default name for the back-end database and store it in the le5 folder in your student files.
8. Set the startup options to hide the Database window, restrict menus, eliminate the built-in toolbars, and open the Switchboard form whenever you open the BuySell database.
9. Test the database password and startup options, and then make one more pass through all the command button options on the Switchboard form.
10. Exit Access.

Attachments
Purchase this Solution

Solution Summary

This posting contains answers to the given questions.

Purchase this Solution


Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.