In Access 2010, you can create data macros that run when you add, update, or delete data in a table. This feature is similar to a "trigger" in Microsoft SQL Server. This video shows you how to create a simple data macro by using the updated Access Macro Designer.
In the video
Use this procedure to add a data macro to a table.
- In the Navigation Pane, double-click the table to which you want to add the macro.
- On the Table tab, in the Before Events or After Events group, click the event that you want to trigger the macro.
Access opens the Macro Designer. If a macro has already been created for this event, Access displays the macro.
- Build or edit your macro by dragging actions from the Action Catalog pane to the macro pane, and then filling in the required arguments for each action.
- When you are finished, click Close on the Design tab of the macro builder, and then click Yes to save your changes.