For Tutor daniel

Shelly Cashman access 2010

Chapter 9: Lab 1

Creating Macros AND a Navigation Form for the ECO Clothesline Database

Skills

·

1 SAM PROJECTS 2010 – CENGAGE LEARNING

· Begin creating a macro

· Add an action to a macro

· Add additional actions to a macro

· Create a menu form containing command buttons

· Create a menu form containing an option group

· Create a macro for the option group

· Add actions to the macro

· Create datasheet forms that incorporate UI macros

· Create a navigation form

· Add tabs to a navigation form

·

Project overview

ECO Clothesline would like an easy way to access the various tables, forms, and reports included in the database. This would make the database much easier to maintain and update.

STUDENT start FILE

SC_Access2010_C9_L1a_FirstLastName_1.accdb (Note: Download your personalized start file from www.cengage.com/sam2010)

Instructions

1. Open the file SC_Access2010_C9_L1a_FirstLastName_1.accdb and save the file as SC_Access2010_C9_L1a_FirstLastName_2.accdb by clicking the "Save Database As" command in Backstage view. (Note: Verify that your name appears in the first record in the _SAMProjects table before you begin. If it does not, then please download a new copy of the start file from the SAM Web site.)

2. Create a macro named Forms and Reports which includes the submacro Open Sales Rep Order Data that will open the Sales Rep Order Data form in read-only mode.

3. Expand the macro to include the submacro Open Sales Rep Master Form that will open the Sales Rep Master Form.

4. Expand the macro to include the submacro Open Customer Master Form that will open the Customer Master Form.

5. Expand the macro to include the submacro Preview Sales Rep Master List that will provide print preview of the Sales Rep Master List.

6. Expand the macro to include the submacro Preview Customer Balance Report that will provide a print preview of the Customer Balance Report.

7. Expand the macro to include the submacro Preview Customer Discount Report that will provide a print preview of the Customer Discount Report.

8. Expand the macro to include the submacro Export Sales Rep Master List that will display the Sales Rep Master List report in .pdf format.

9. Expand the macro to include the submacro Export Customer Balance Report that will display the Customer Balance Report in .pdf format.

10. Expand the macro to include the submacro Export Customer Discount Report that will display the Customer Discount Report in .pdf format.

11. Create the Forms List menu form shown in Figure 1. The command buttons should use the macros and submacros you created in Steps 2 – 4 to open the Customer Master Form, the Sales Rep Master Form, and the Sales Rep Order Data form.

Figure 1 Forms List Menu Form

12. Create the Reports List menu form shown in Figure 2. The option group should use the macros and submacros you created in Steps 5 – 10 to preview and export the three reports (the Sales Rep Master List, the Customer Balance Report, and the Customer Discount Report).

Figure 2 Reports List Menu Form

13. Create a datasheet form for the Customer table and name the form Customer. Create a UI macro for the Customer form. When a user clicks a customer number on a row in the datasheet, the Customer Master Form should appear in a pop-up form.

14. Create a datasheet form for the Sales Rep table and name the form Sales Rep. Create a UI macro for the Sales Rep form. When a user clicks a sales rep number on a row in the datasheet, the Sales Rep Master Form should appear in a pop-up form.

15. Create the Main Menu navigation form shown in Figure 3. Double-check that the Customer tab should display the Customer form you created in Step 13, and the Sales Rep tab should display the Sales Rep form you created in Step 14. The Forms tab should display the Forms List form you created in Step 11, and the Reports tab should display the Reports List form you created in Step 12.

Figure 3 Main Menu Navigation Form

Save your changes, compact and repair the database, and exit Access. Follow the directions on the SAM Web site to submit your completed project.

3 SAM PROJECTS 2010 – CENGAGE LEARNING