Reference no: EM13943538
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.
|
Context of a systems development project
: Outline the issues that Susan should consider which would support the purchase of a software package. Within the context of a systems development project, when should the decision of "make-versus-buy" be made? How should Susan proceed? Explain your..
|
|
How are the two traditions different
: Identify which features of these two traditions you saw as non-comparable. How are the two traditions different? If you had grown up in the non-Western culture, do you think you would prefer these two traditions over the ones to which you have bee..
|
|
Marlene grady and pauline monroe are partners
: Marlene Grady and Pauline Monroe are partners engaged in operating The G&M Doll Shop,doll shop is located in a state that requires unemployment compensation contributions of employers of one or more individuals.
|
|
Describe one type of health inequality or inequity
: Describe one type of health inequality/inequity that is seen in healthcare that also has an ethical consideration
|
|
Define the hot keys for each command button.
: 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 th..
|
|
Determine the fourier series for the function
: Determine the r.m.s. voltage of V2 if the reading on the ammeter, which reads true r.m.s, is to be 5 A. Calculate the power factor of the load for the conditions set in (a) above.
|
|
Differences between workplace writing and academic writing
: Think about the differences between workplace writing and academic writing. Find a one-paragraph sample of workplace writing from a textbook, a letter you received from an organization, a memo you found on the Internet, etc
|
|
Are all the properties the same for different controls
: How are Integer and String data types used in an application?
|
|
Gerald boards produces two kinds of skateboards
: Gerald Boards produces two kinds of skateboards. Selected unit data for the two boards for the last quarter. Compute the per-unit cost for each product
|