New Perspectives Access 2019 | Module 10: SAM Project 1b Ridgedale College CREATING MACROS   GETTING STARTED Open the file NP_AC19_10b_FirstLastName_1

Subject:MS AccessPrice:19.99 Bought3

Share With

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

Ridgedale College

CREATING MACROS

GETTING STARTED

• Open the file NP_AC19_10b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_10b_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 Admissions Office at Ridgedale College to help track grants awarded to professors as well as teaching assistant assignments by class. You have created an Access database to organize these details. In this project, you will improve the database by creating macros. Complete the following:
    
   1. Create a new macro in Design View and add the OpenReport macro action.
   2. Modify the OpenReport macro action to open the ClassMasterList report in Print Preview using the other default macro argument values.
   3. Save the macro with the name OpenClassMasterList and run it. 
   4. Close the ClassMasterList report, then close the OpenClassMasterList macro.
2. Open the OpenForms macro in Design View and complete the following:
   1. Collapse the first OpenForm action that opens the ClassEntry form. 
   2. Expand the second OpenForm action and use Datasheet as the value for the View argument. 
   3. Delete the third OpenForm action that opens the GrantEntry form.
      Save and close the OpenForms macro.
3. Open the OpenTAReports macro in 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 CopyObject action as the third action in the macro. 
   4. Change the New Name argument to TAListCopy, the Source Object Type argument to Query and the Source Object Name argument to TAList. (Hint: Leave the Destination Database argument blank to indicate that the copy is to be made in the current database.)
   5. Position the CopyObject action as the second action in the macro.
      Save and close the OpenTAReports macro.
4. Open the ViewData macro in Design View and complete the following:
   1. Collapse the three existing macro actions within the OpenQueries submacro, then collapse the submacro.
   2. After the existing OpenQueries submacro, add a new submacro with the name OpenTables and add an OpenTable action to open the ClassMasterList table in Datasheet View to the submacro. 
      Save and close the ViewData macro.
5. Open the HighCreditMessage macro in Design View and perform the following actions:
   1. Add a SetProperty macro action within the If block.
   2. Use lblHighCredits for the Control Name argument, Visible for the Property argument, and True for the Value argument.
   3. Add a SetProperty macro action within the Else block.
   4. Use lblHighCredits for the Control Name argument, Visible for the Property argument, and False for the Value argument in the Else block.
      Confirm that the HighCreditMessage macro matches Figure 1, then save and close it.

Figure 1: Macro Design View of the HighCreditMessage Macro

6. Open the ClassEntry form in Design View and complete the following:
   1. Attach the HighCreditMessage macro to the On Current event of the form. 
   2. Switch to Form View and navigate through several records. Those with a value greater than 3 in the Credits field should display a label that reads "Note that this is a high credit class!".  Those with a value of 3 or less should not display the message.  
      Save and close the ClassEntry form.
7. Open the GrantEntry form in Design View and complete the following:
   1. Use #FFF200 for the Hover Color property for the Print command button. (Hint:  #FFF200 is yellow).
   2. Use #ED1C24 for the Hover Fore Color property for the Print command button. (Hint:  #ED1C24 is red).
   3. Save the form, display it in Form View, and hover over the Print command button to test the change. 
      Close the GrantEntry 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.