Exam 11: Creating and Running Macros

The Disable all macros with notification option is the default setting unless you choose another one.

A(n) ____________________ macro is a macro that performs an action within an object.

When you record a macro, you can include multiple actions in it.

When you create a command button with an embedded macro, you can view the event and the embedded macro using the ____ Sheet.

Comments appear in ____ in the macro window, making them easy to identify.

Case AC 11-1 The Accounting department manually runs queries every Monday morning to verify the reconciliation of salesperson salary. They have asked the Information Technology (IT) department for some assistance in saving time with this repetitive task. Because the report involves salary and private personnel information, security is an utmost priority. As the senior IT database analyst, you volunteer to help out with this request. You explain that you will create a macro as part of the solution because ____.

Case AC 11-2 Craig has responsibility for updating the frozen food inventory for the Frosty Freeze Snack Shop each night. On Sunday evenings, Craig wants to print five forms displaying weekly summary inventory results that he provides to his five different suppliers and his manager the next morning. He does not want the form to remain open after it is printed. As Shelly is a part-time employee working at the Frosty Freeze Snack Shop to help pay her way through college, Craig asks Shelly if she can write the macro to open and print the report. As Shelly starts writing the macro she decides to include multiple actions starting with the print action. Craig expresses some concern as he recalls from his Advanced Access 2010 class that ____.

Because macros often need to be changed, it is a good idea to include a comment for each ____.

When a macro is being ____, all of the selections you make are translated into code.

You can create a macro in the Macro window and then attach it to the object.

As a best practice, you should set the security level in Access to Disable all macros with notification or Disable all macros except digitally signed macros.

A comment can affect the way the macro is executed.

A macro automates common, repetitive tasks you perform in Access, thereby saving disk space.

You would use the ____ form event to run an embedded macro when a form is closed.

To create a macro, you open the ____________________ window by clicking the Create tab and then clicking the Macro button in the Macros & Code group.

To run an embedded macro, you simply click on the Run button.

Macro settings can be viewed by clicking the View tab on the Ribbon, and then clicking the Macro Security button in the Code group.

Embedded macros have queries that run the macro, such as On Click.

To help protect your data from the corruption caused by a virus hidden in a macro, you can set one of ____ macro security levels in Access.