Access 2010 New Feature: Data Macros

One of the newest features in Access 2010 that I am excited about is the ability to create Data Macros. In previous versions of Access, if you wanted to automatically update data in a table you’d have to attach or embed a macro to a form that would then update data inside a table. Now, with Data Macros, you can attach logic directly to table and record events, a feature quite similar to SQL triggers.

Data macros are portable, secure and scalable for a server/service environment. Data macros can even survive the trip to the web if you choose to convert your database to a web database.

Data Macros can be used for a variety of purposes. Everything from tracking when a record was last modified (something that I demonstrate how to do in my new Access 2010 Training course) or deleted to preventing blank values if a certain condition is not met.

Today we’ll take a look at the steps it takes to create data macros in Access 2010 and I’ll also show you how to paste macros into a text editor as XML.

1. Open a table to Design View and in the Table Tools Design Tab, in the Field, Record & Table Events Group, click on the button “Create Data Macros.”

Access 2010 Data Macros

2. Click on a Table Event to launch your Macro Builder.

Access 2010 Data Macros

3. Next, write your macro and save.

Access 2010 Data Macros

Note: Data macros cannot process multi-valued or attachment data-types.

Did You Know?

You can also paste macros into a text editor as XML, making it easy to edit or even share macros with others.

1. Simply open and select your macro (if selected, a gray box will appear around the actions).

Access 2010 Data Macros

2. Right-click and choose Copy.

Access 2010 Data Macros

3. Open a text editor like Notepad and paste.

Access 2010 Data Macros

Learn More about Access 2010 in Train Signal’s Access 2010 Training


This site uses Akismet to reduce spam. Learn how your comment data is processed.