Purchase Solution

Creating a User Interface: Switchboard for the BuySell 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:

Deliverables:

1. Start Access, and then open the BuySell database located in the le5 folder of the zip file.

2. Design and create a switchboard form named Switchboard. Use the figure below and the following descriptions as a guide in designing the switchboard.

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.

Create the switchboard and place the command buttons on the form.
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.

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

Purchase this Solution


Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C# variables and classes

This quiz contains questions about C# classes and variables.

C++ Operators

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

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.