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.
This posting contains answers to the given questions.
Creating Search Table Based on Combo Box for Access Database
When 1 is selected for choice, check to see if the combination of 1 for choice and zip code exists. If combination exists, message "A primary location already exists for this zip code: If not, save code already in place.
When 2 is selected for choice, check to see if the combination of 12for choice and zip code exists. If combination exists, message "A secondary location already exists for this zip code: If not, save code already in place.
When 3 is selected for choice, Update Include field in table to "Out of Area".View Full Posting Details