This module discussed how Access macros allow you to automate tasks in the database.
In this module, you learned how to:
- Determine the usefulness of an Access macro
- Use the Access Macro Builder to create and run an Access macro
- Assign a macro to a command button on a form
- Run different types of queries by using macros
- Work with some other useful macros that are available in Access
For many years, Access has supported two different ways of accomplishing programming tasks:
- Visual Basic for Applications (VBA) and
- macros.
The term
macro as it relates to other Office applications such as Word or Excel, typically refers to VBA.In Access, however, the term
macro means something else entirely. Compared with VBA, a macro in Access provides a reduced set of functionality for achieving certain tasks. These tasks might be as simple as opening a form or report, or something more complex such as running a series of queries in a particular order and then exporting the data to Excel. In some situations, one of these tasks may also include calling into VBA code. This module looked at some common scenarios in which you might use macros in Access and how to write these macros.