New Perspectives Access 2019 | Module 10: SAM Project 1a Global Human Resources Consultants CREATING MACROS GETTING STARTED Open the file NP_AC19_10a_FirstLastName_1

Subject:MS AccessPrice:20.99 Bought4

Share With

New Perspectives Access 2019 | Module 10: SAM Project 1a

Global Human Resources Consultants

CREATING MACROS

GETTING STARTED

• Open the file NP_AC19_10a_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_10a_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. You work in the Software Division of Global Human Resources Consultants (GHRC) that sells modular Human Resource (HR) software to large international companies. For high-level planning purposes you have created an Access database to track new clients, the HR software modules they have purchased, and the lead consultant for each installation. In this project you will improve the database by creating macros. Complete the following:
   1. Create a new macro in Macro Design View and add the OpenForm macro action.
   2. Modify the OpenForm macro action to open the ConsultantSalary form in Form View using the other default macro argument values. 
   3. Save the macro with the name OpenConsultantSalaryForm and run it. 
   4. Close the ConsultantSalary form, then close the OpenConsultantSalaryForm macro.
2. Open the OpenClientReports macro in Macro Design View and complete the following:
   1. Collapse the first OpenReport action that opens the ClientDetails report. 
   2. Expand the second OpenReport action and use Report as the value for the View argument. 
   3. Delete the third OpenReport action that opens the Revenue report. Save and close the OpenClientReports macro.
3. Open the OpenConsultantReports macro in Macro Design View, complete the following:
   1. Expand both of the macro actions.
   2. Open the Action Catalog if it is not already open, and show all actions within it. 
   3. Add the DeleteObject action in the macro. 
   4. Change the Object Type argument to Query and the Object Name argument to SortedConsultantImport.
   5. Position the DeleteObject action as the second action in the macro. Save and close the OpenConsultantReports macro.
4. Open the OpenObjects macro in Macro Design View and complete the following:
   1. Collapse all existing macro actions within the Submacro, then collapse the Submacro.
   2. After the existing Submacro, add a new Submacro with the name OpenQueries and one action to open the Revenue query in Datasheet View. Save and close the OpenObjects macro.
5. Open the Travel macro in Design view and perform the following actions:
   1. Add a SetProperty macro action within the If block.
   2. Use TravelAllowance for the Control Name argument, BackColor for the Property argument, and #00FF00 for the Value argument. (Hint: #00FF00 is green).
   3. Add a SetProperty macro action within the Else block.
   4. Use TravelAllowance for the Control Name argument, BackColor for the Property argument, and #FFFFFF for the Value argument in the Else block. (Hint: #FFFFFF is white).
      Confirm that the Travel macro matches Figure 1, then save and close it.

Figure 1: Travel Macro in Design View

6. Open the ConsultantSalary form in Design View and complete the following:
   1. Attach the Travel macro to the On Current event of the form. 
   2. Switch to Form View and navigate through several records. Those with "USA" in the Reside text box should display a green background in the Travel Allowance text box. Save and close the ConsultantSalary form.
       
7. Open the ClientEntry form in Design View and complete the following:
   1. Use #0000FF for the Hover Fore Color property for the Close command button. (Hint: #0000FF is blue).
   2. Save the form, display it in Form View and hover over the Close command button to test the change. Close the ClientEntry form.

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.