Microsoft Access 2000

Access 2000 Tutorial 9 Internet Assignments

Lopez Lexus Dealerships

The pre-owned sales division manager, Buck Sherman, has asked you to design a user-friendly interface for accessing forms, reports, and queries from the Lexus database that are specific to his division.. Buck asks you to create the switchboard for the Lexus database by completing the following:

1. Log on to the Internet and use your Web browser to go to the Course Technology home page. Click the Student Online Companions link, click the New Perspectives on Microsoft Access 2000 link, and then click the Tutorial 9 Internet Assignment link.

2. Click the link to download the Sales file. Save the Sales file on your Internet Assignments Disk.

3. In the tutorial you learned about using macros on a form that open message boxes, cause sounds to occur, and cause the pointer to change. You also can create these types of changes and use other GUI elements on Web pages using HTML (hypertext markup language) codes. Use your Web browser to find more information about HTML, and see if you can find Web pages that use different GUI elements.

4. Log off of the Internet, and then close your Web browser.

5. Make sure your Internet Assignments Disk is in the appropriate disk drive, start Access, and then open the Lexus database.

6. Design and create a dialog box form named Reports Dialog Box that has the following components and characteristics:

1. The text "Lopez Lexus" appears in the title bar.
2. A list box displays all the report names contained in the ReportNames table.
3. The text "Reports Available" appears as a heading above the list box. The text should appear as 16-point, bold font.
4. Two command buttons appear below the list box. The left command button displays the Print Preview icon, and the right command button displays the Close window icon.
5. Double-clicking a report name has the same effect as clicking the left command button. Both events cause Access to display the Print Preview window for the selected report. (You will add the Visual Basic code for these events in Tutorial 10. For now, double-clicking or clicking should cause no action to occur.)
6. Clicking the Close command button causes Access to close the dialog box.
   
   

7. Design and create a switchboard form named Switchboard, using the following guidelines. (Remember that you will need to create a macro group which will respond to the switchboard)

   The title should be "lopez Lexus"

   The names of the command buttons are:

   • Customers
     (Opens the Customers Table)
   • 2000 Cars
     (Opens the 2000 Cars Form)
   • Potential Lexus customers
     (Opens the Potential Customers Form)
   • Models By Dealer
     (Opens the Models by Dealer Crosstab Query)
   • Reports
     (Opens the Reports Dialog – Note: include the ellipses)
   • Go To Access
     (Transfers control to Access)
   • Quit Access
     (Closes the database and Access)

8. The command buttons should appear to the left of the command button names.

9. Go to the Course Technology site, Access 2000 Tutorial 4 Internet Assignment.
   
   There is a logo on this page. Save the Logo on your disk (Hint: Right click the image then select save image).
   
   Insert the logo on the left side of the Switchboard form. You will need to set the size mode to "stretch" in order to see the picture on the Switchboard (Hint: right click the image, select the Format tab, select size mode, select stretch).
   
   Once you have set the image to "stretch", you can resize it to the size you feel is appropriate.

10. Close the switchboard and close Access.