Microsoft Office Tutorials and References
In Depth Information
You see the list of actions in the macro. The Action Catalog on the right
side of the window shows a list of the actions that you can add to the
macro, grouped by type. The Design tab of the Ribbon displays
2. Enter the action that you want the macro to take, as described in
“Taking action,” later in this chapter.
3. For each action, specify the arguments for that action in the form that
Click each box in turn and set the value of the argument. For some
arguments, you type a value; for others, you choose a value from a list. If a
down arrow appears at the right end of the box, click it to see a
dropdown menu of your options.
4. Repeat Steps 2 and 3 for each action you want the macro to take.
When you run the macro, Access executes the actions you specified,
starting on the first row of the macro and proceeding until it reaches a
When you edit a macro, you open it in Design view, which opens the Macro
Naming, saving, and editing macros
Before you run a macro, you need to save it with a name. Press Ctrl+S, click
the Save button on the Quick Access toolbar, or click the Close button and
then click the Yes button in the Save As dialog box to save the macro. (The
Save As dialog box appears the first time you save a macro. Name the macro,
and click OK.)