Shelly Cashman Access 2016 | Module 8: SAM Project 1b All Around Outside Maintenance MACROS, NAVIGATION FORMS, CONTROL LAYOUTS GETTING STARTED   Open the file SC_AC16_8b_ FirstLastName _1.accdb , available for download from the SAM website.   Save the file as SC_AC16_8b_ FirstLastName _2.accdb by changing the “1” to a “2”. o Hint : If you do not see the .accdb file extension in the Save As dialog box, do not type it. Access will add the file extension for you automatically.   Open the _ GradingInfoTable table a nd ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. Open the Preview Client Financial Report macro in Design View. Change the View argument to Print Preview . Save the change to the macro, and then close the Preview Client Financial Report macro. 2. The Open Basic Property List macro contains an error. Complete the following tasks to correct the macro: a. Open the Open Basic Property List macro in Design View. b. Click the Single-Step button. c. Run the macro. d. Correct the error. ( Hint : The macro should open the Basic Property List report in Print Preview mode.) e. Click the Single-Step button again to deselect it. Save and close the Open Basic Property List macro. 3. Create a new macro with two submacros by following the directions below: a. When the Macro Design window opens, display the Action Catalog. b. Add the first submacro to the macro, using Open Property Table as the name for the submacro. c. In the first submacro, use the OpenTable action to open the Property table in Datasheet View and in Edit data mode. d. Add a second submacro to the macro, using Open Client Table as the name for the macro. e. In the second submacro, use the OpenTable action to open the Client table in Datasheet View and in Edit data mode. f. Save the macro with the name OpenTables . Confirm that your macro matches Figure 1 below, and then close the macro. Figure 1: OpenTables Macro 4. Open the Client Types table in Datasheet View, and then create a data macro for the table by completing the following tasks: a. Click the Before Change button on the Table Tools tab. b. Create the macro shown in Figure 2 on the next page. Save and close the macro, and then save and close the Client Types table. Figure 2: Data Macro for a Before Change Event 5. Create a Datasheet form based on the State table, and then save the form with the default name State . Close the form. 6. Create a Navigation form for the database with the following options: a. Use the Horizontal Tabs layout. b. Add the Manager , Client , and Property Datasheet forms to the Navigation form in that order. c. Change the title (in the Form Header) to Basic Navigation Form . ( Hint: Do not type the period.) d. Save the navigation form with the name Basic Navigation Form . ( Hint: Do not type the period.) Confirm that your form matches Figure 3 on the next page. Save and close the Basic Navigation Form Figure 3: Basic Navigation Form – Form View 7. Open the Client form in Datasheet View, and then complete the following tasks to create a UI macro for the form: a. Select the ClientNumber column. ( Hint : The ClientNumber column has the caption “CL#”.) b. Click the Property Sheet button. c. Click the Build button for the On Click event, and then select Macro Builder . d. Create a macro that opens the Client Master Form when a user selects a value in the ClientNumber column. The macro actions are shown in Figure 4 on the next page. Save and close the macro, and then save and close the form.