1. Create a new macro in Macro Design View and add the OpenForm macro action to open the PropertyEntry form in Form View using the other default macro argument values. Save the macro with the name OpenPropertyEntryForm and run it. Close the PropertyEntry form, and then close the OpenPropertyEntryForm macro. 2. Open the HomeReports macro in Design View and collapse the first OpenReport action that opens the HomeInfo report. Expand the second OpenReport action and make Print Preview the value for the View argument. Delete the third OpenReport action that opens the StateListing report. Save and close the HomeReports macro. 3. Open the ManagerReports macro in Design View and expand both of the existing macro actions. Open the Action Catalog if it is not already open and show all actions within it. Add the ImportExportSpreadsheet action to the macro. Change the Transfer Type argument to Export and enter Manager for both the Table Name and File Name arguments. Move the ImportExportSpreadsheet action to be the first action in the macro, and then save and close the ManagerReports macro. 4. Open the OpenForms macro in Design View and collapse all existing macro actions and submacros. Add a new submacro with the name OpenHomeStyles and add one action within the new submacro to open the HomeStyles form in Form View. Save and close the OpenForms macro. 5. Create a new macro in Design View and add an If program flow block. Use the test [AverageTestScore]>95 in the If block and add a SetProperty macro action within the If block. Use GreatScores for the Control Name argument, Visible for the Property argument, and True for the Value argument. Add an Else block and add a SetProperty macro action within it. Again use GreatScores for the Control Name argument and Visible for the Property argument, and use False for the Value argument. Save the macro with the name HighScore as shown in Figure 1 and then close it. 6. Open the ManagerEntry form in Design View and attach the HighScore macro to the On Current event of the form. Switch to Form View and navigate through several records. Two of the six records should display the Great Scores!! label below the chart. Save and close the ManagerEntry form. 7. Open the PropertyEntry form in Design View and use #FF0000 for the Hover Fore Color property for the Close command button. (Hint: #FF0000 is red.) Save the form, display it in Form View, and hover over the Close command button to test the change in font color. Save and close the PropertyEntry form. 8. In Design View of the Managers table, create a data macro on the Before Change event. If the FinalTest value is greater than 94, use the SetField action to set the value of the