Access 2016 Advanced

Lesson 10 - Creating Macros

Access 2016

W ORKING WITH M ACROS



Discussion

A macro performs a set of commands in sequence. While macros in word processors and spreadsheets are used mainly to duplicate keystrokes or mouse movements, macros in Access often automate an action or a series of actions. Actions include opening tables, printing forms, finding records, or applying filters. Macros can even be used to add command buttons, create menus and toolbars, and build complete applications.

Macro commands in Access consist of an action and its arguments. The action is the task to be performed, such as opening a form. The arguments determine the specifics for the action, such as which form to open.

You create a macro in Access in the Macro Designer window. The Macro Designer works inside Access and features an IntelliSense builder – as you choose your action, fields appear allowing you to set your conditions and parameters.

O PENING THE M ACRO DESIGNER W INDOW



Discussion

The Macro Designer window contains a drop-down list of actions you might want a macro to perform.

You can either choose an action from the Add New Action drop-down list or choose it from the Action catalog. Actions in the Action Catalog are grouped by their function. To add an action from the Action Catalog to the macro window, either double-click the macro or click and drag it to the macro window from the Action Catalog.

Page 104

OFFICEPRO, Inc.