Video: Create a data macro

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

  1. In the Navigation Pane, double-click the table to which you want to add the macro.

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

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

  4. When you are finished, click Close on the Design tab of the macro builder, and then click Yes to save your changes.

Applies To: Access 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language