O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a Macro

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required