Using Access, open the BuySell database located in the le5 folder of the attached ['[login to view URL]' file][1]. Design and create a switchboard form named Switchboard. Use the figure attached 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 [login to view URL] the switchboard and place the command buttons on the [login to view URL] “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 [login to view URL] the background color for the switchboard, as shown in figure attached, 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 [login to view URL] the Exit to BuySell command button to close the Switchboard [login to view URL] 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 [login to view URL] 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 [login to view URL] the database password and startup options, and then make one more pass through all the command button options on the Switchboard form. Exit Access.
## Deliverables
I need you to create a user-friendly interface for the BuySell database. I need you to create a switchboard for the BuySell database by completing the above instructions.
I have an example of what I need but I cannot attach, the graphic, but I will send it to the winning bidder.
## Platform
Microsoft Access