With the latest version of Microsoft Access (2010), there are now 3 types of Access macros developers can utilise and release the power of this application further.
The 3 types are as follows:
- Macro Objects
- Embedded Macros
- Data Macros
Macro objects are avialable to all versions of Microsoft Access but version 2010 has a new interface tool plus more key commands and functionality. It is where you store the general procedures to your database.
Embedded macros were introduced from version 2007 and now is the default procedure when creating event driven procedures in forms and some reports.
Data macros which is exclusive to Access 2010 is the new and powerful to trigger procedures at the data level (via a Table) which is similar to Triggers in SQL Server.