O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Macros

Let's shift gears a bit and take a look at macros.

A macro is an object that automates tasks. It is a set of one or more actions that perform specific operations. That definition, plagiarized from Access Help, gives you little idea of what macros are or how you can use them. Let's create a macro to get a better feel:

1.
If the frmOrders form is still open, close it and save your changes.
2.
In the Database window, click the Macros button and choose New. Unlike other Access objects, there is only this one view for a macro.
3.
Press F11 to switch to the Database window. Click the Forms tab.
4.
Choose Window, Tile Vertically.
5.
Select frmCustomers. Drag and drop its icon to the first row of the Action column, which now reads OpenForm. You have ...

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