# How to Create Macro in MS Access

> To create a macro in MS Access, go to the Create tab and click Macro in the Macros & Code group. Select an action from the Action Catalog, configure its arguments, and arrange actions in sequence. Finally, click Save, name the macro, click OK, and close the Macro Designer.

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

## Steps

1. Go to the 'Create' tab on the ribbon.
2. Click on 'Macro' in the 'Macros & Code' group. This opens the 'Macro Designer' window.
3. In the dropdown under 'Action Catalog', select the desired action.
4. After selecting an action, configure its arguments in the provided fields such as the 'Form Name', 'View' and 'Data Mode'.
5. Each action will execute in sequence.
6. Click the 'Save' button.
7. Give the macro a descriptive name and click 'OK'.
8. Close the 'Macro Designer' and that's it, you have successfully created a macro in MS Access.