New Perspectives Access 2019 | Module 10: SAM Critical Thinking Project 1c Global Human Resources Consultants CREATING MACROS     GETTING STARTED Open the file NP_AC19_CT10c_FirstLastName_1

Subject:MS AccessPrice:19.99 Bought4

Share With

New Perspectives Access 2019 | Module 10: SAM Critical Thinking Project 1c

Global Human Resources Consultants

CREATING MACROS

• GETTING STARTED

• Open the file NP_AC19_CT10c_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_CT10c_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), which sells modular human resources (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 tasks:
   1. Create a new macro and add the OpenForm macro action.
   2. Modify the OpenForm macro action to open the ConsultantSalary form in Form view.
   3. Save the macro with the name OpenConsultantSalaryForm and run the macro.
   4. Close the ConsultantSalary form, and then close the OpenConsultantSalaryForm macro.
2. Make the following modifications to the OpenClientReports macro:
   1. Edit the second OpenReport action to open the ClientListing report in Report view.
   2. Delete the third OpenReport action that opens the Revenue report.
      
      Save and close the OpenClientReports macro.
3. Make the following modifications to the OpenConsultantReports macro:
   1. Add the DeleteObject action in the macro.
   2. Modify the DeleteObject action to delete the SortedConsultantImport query.
   3. Position the DeleteObject action as the second action in the macro.
      
      Save and close the OpenConsultantReports macro.
4. Make the following modifications to the OpenObjects macro:
   1. 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. Create a new macro as follows:
   1. Add an If program flow block.
   2. Use the conditional expression [Reside] = "USA" in the If block.
   3. Add a SetProperty macro action within the If block.
   4. Use TravelAllowance for the Control Name argument, BackColor for the Property argument, and #00FF00 for the Value argument. (Hint: #00FF00 is green.)
   5. Add an Else block, and then add a SetProperty macro action within it.
   6. 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.)
      
      Save the macro with the name Travel as shown in Figure 1, and then close it.

 Figure 1: Travel Macro in Design View

6. Open the ConsultantSalary form in Design view, and then attach the Travel macro to the On Current event in the form.
   
   In Form view, records with "USA" in the Reside text box should display a green background in the Travel Allowance text box for each entry. Save and close the ConsultantSalary form.
7. Open the ClientEntry form and complete the following tasks:
   1. Set the color of the Close command button to blue when the button is hovered over. (Hint: #0000FF is blue.)
   2. Save the form, display it in Form view, and then hover over the Close command button to test the change.
      
      Close the ClientEntry form.
8. Within the Consultant table, complete the following tasks:
   1. Create a data macro on the Before Change event.
   2. If the Reside field value is "USA" and the ContractEmployee field value is True, use the SetField action to set the value of the TravelAllowance field to 2000 as shown in Figure 2. Save and close the data macro.
   3. Open the Consultant table in Datasheet view, and then change the ContractEmployee field value to True (Yes) for the first two records (ConsultantID 110345 Jenette Masterson and ConsultantID 110347 Victorina Hogg) to test your data macro.
      
      Close the Consultant table.

 Figure 2: Data Macro in Consultant Table

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.