Microsoft® Access® 2010 24-Hour Trainer

46

Creating Macros in Access 2010

As you've seen in previous lessons, Access 2010 provides the ability to create Macros to execute simple functionality in a database application, without having to write code. This is accomplished through the use of the Macro Builder, which has been completely overhauled along with the other macro features in Access. This lesson guides you through the basics of creating macros using the Access 2010 Macro Builder and discusses the highlights of its features.

LESSON SETUP

Creating macros is very easy and requires very little knowledge of Access. You should already be familiar with Access databases and have a basic knowledge of the major database object types. To begin creating macros in Access, you only need an empty database to build standalone macros. However, it helps to have other database objects, such as forms and reports, to utilize many of the macro features that are available.

THE THEORY OF MACROS

Macros in Access are nothing more than a set of predefined actions that can be called, very easily, to perform their designated tasks. Often viewed as a simpler alternative to writing VBA code, literally hundreds of common macro operations can be executed without ever having to write a single line of code. For example, there are macros to open and close database objects, filter forms and reports, and even start the common built-in Access wizards and dialogs. The true advantage to macros is that the Macro Builder makes it very easy to select any ...