SQLConfiguration SQLConfiguration

Access Macros  «Prev  Next»
Lesson 7

Working with Access Macros Conclusion

This module discussed how Access macros allow you to automate tasks in the database.
In this module, you learned how to:
  1. Determine the usefulness of an Access macro
  2. Use the Access Macro Builder to create and run an Access macro
  3. Assign a macro to a command button on a form
  4. Run different types of queries by using macros
  5. Work with some other useful macros that are available in Access

For many years, Access has supported two different ways of accomplishing programming tasks:
  1. Visual Basic for Applications (VBA) and
  2. 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.

Running Queries with Macros - Quiz

Click the Quiz link below to answer a few questions about running queries with macros and various macro actions.
Running Queries with Macros - Quiz