Homework answers / question archive / New Perspectives Access 2019 | Module 10: End of Module Project 1 Homestead Partners Creating Macros GETTING STARTED Open the file NP_AC19_EOM10-1_FirstLastName_1

New Perspectives Access 2019 | Module 10: End of Module Project 1 Homestead Partners Creating Macros GETTING STARTED Open the file NP_AC19_EOM10-1_FirstLastName_1

MS Access

Share With

New Perspectives Access 2019 | Module 10: End of Module Project 1

Homestead Partners

Creating Macros

GETTING STARTED

• Open the file NP_AC19_EOM10-1_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_EOM10-1_FirstLastName_2.accdb by changing the “1” to a “2”.
  • If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• Open the _GradingInfoTable table and 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. 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 TestBonus field to 2000 as shown in Figure 2. Save and close the data macro, and then save and open the Managers table in Datasheet View. Enter 95 in the FinalTest field for ManagerID 1 Washington. Enter 94 in the FinalTest field for ManagerID 2 Perez to test your data macro. Close the Managers table.