Access DB

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:

Start Access, and then open the BuySell database located in the le5
folder of the HYPERLINK
"https://mycampus.aiu-online.com/courses/ITD320/Assignment_Assets/1_u3ip
s.zip" \t "_blank" zip file .

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.

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.

Click the Exit to BuySell command button to close the Switchboard form.

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.

Set the database password to "password" (no quotes).

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.

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.

Test the database password and startup options, and then make one more
pass through all the command button options on the Switchboard form.

Exit Access.



Zip your le5 folder containing your Access files.

Please submit your assignment.