2007 Microsoft® Office System Plain & Simple

Customizing Access

A macro is a series of automated steps, such as opening a report or form or displaying a message box that you create and save. After you save the macro, you can run it whenever you want, either by right-clicking it and clicking the Run option, or by running it when something specific happens, such as clicking a button on a form. If you export Access tables to other formats, print records, or search for records and are tired of going through the process manually, you can create a macro that does it for you.

Create a Macro

1. Click the Create tab.

2. Click the top part of the Macro button.

3. Click the down arrow in the first Action cell. ...