Using Access Data Macros

This chapter specifically covers data macros, which add yet another reason that macros in Access 2019 are a more attractive option than ever before. A data macro is logic users attach to a table to enforce business rules at the table level. Data macros are intended to make it easier to ensure consistent data handling throughout their application. The chapter discusses five different macro-programmable table events: BeforeChange, BeforeDelete, AfterInsert, AfterUpdate, and AfterDelete. Data macros use the same macro builder used to create embedded and user interface macros. The Action Catalog on the right side of the macro builder serves as the repository of macro actions the users add to their data macros. Data macros are attached directly to Access tables and not to individual fields. If the users have a situation where more than a few fields must be monitored or updated, the macro may become quite complex.