Exam 11: Creating and Running Macros

To run a macro means to have it perform a(n) ____, automated task.

You choose macro security level settings in the ____ section of the Access Options dialog box.

If a virus attaches itself to a macro, it can cause damage when you ____ the macro.

To run a macro in the Navigation pane, right-click the macro name, and then click ____ on the shortcut menu.

After you create and save a macro, you need to ____________________ the macro in order to have it perform the recorded steps.

The filter in a macro is typically based on a ____ in the database.

A(n) ____________________ is a series of actions that you want Access to perform.

To run a macro using the Database Tools tab, click the Run Macro button in the Macro group, select the macro in the Run Macro dialog box, and then click the ____ button.

To edit a macro, you work in the Macro window.

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. Unfortunately, when the inventory form ran using the new macro, all of the forms did not close after the macro ran. This most likely occurred because ____.

After you select an action, Access displays the argument(s) ____ the action.

By running a macro, you can ensure ____.

FIGURE AC 11-1 In the accompanying figure, ____ points to the area where you click to display a list of actions.

Within the Run Macro dialog box, click the ____ appearing next to the Macro Name text box to provide a list of all the macros in the database.

Explain how Access helps to protect data from corruption caused by a virus hidden in a macro. Be sure to explain possible options.

FIGURE AC 11-1 In the accompanying figure, the area where you type the name of an action to search for is referenced by ____.

____ macros have events that run the macro.

You can create an object and have a macro embedded as you work through a wizard.

____ is the program used to create macros.

To run a macro using the Macro Tools Design tab, click the ____ button in the Tools group.