# How to Create Data Macros MS Access

> To create data macros in Access, select 'Design View' in the 'Tables' section, click 'Table Design' in the ribbon, and choose 'Create Data Macros'. Select a trigger event, add actions in the 'Data Macro Editor', and click 'Save' in the 'Macro Tools' tab to finish.

Canonical: https://livedemo.ai/tutorials/how-to-create-data-macros-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a397fab56e05a00fdff85/preview?step=1

## 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.
