How to Create Autoexec Macro MS Access

‍

‍

Follow these steps to create an AutoExec macro:

‍

1. Go to the 'Create' tab in the ribbon.
2. Click on 'Macro' in the 'Macros & Code' group.
3. In the macro design window, choose the actions you want the macro to perform. Use the drop-down in the 'Action' column to select an action.
4. Configure each action's properties.
5. Click the save icon to proceed.
6. Name the macro 'AutoExec', this name is mandatory for it to run automatically. Click 'OK' to save.
7. Close and reopen the database. Click 'Run'.
8. The AutoExec macro will run automatically.