How to Create Data Macros MS Access

Quick summary

Data macros in Microsoft Access let you automate actions that run automatically when table events occur, such as record insertions or updates. This tutorial walks you through opening the Data Macro Editor, selecting a trigger, adding actions, and saving the macro from the Macro Tools tab.

Steps

1. Go to the Tables section in the Navigation Pane and select Design View.
2. Select Table Design in the ribbon.
3. Click Create Data Macros in the Macros group.
4. Select a trigger event that will trigger the macro.
5. In the Data Macro Editor, add the actions you want the macro to perform.
6. After defining the macro, click Save in the Macro Tools tab.