Macro Types and Security

Now that you are familiar with how to create macros using Access 2010, you have a number of basics to consider. The macro security built into Access is very important to understand, so that your macros will run properly when executed. Also, it is important to understand the difference between embedded macros and standalone macros. This lesson discusses these concepts and provides some examples of working with these features in Access 2010.


The only requirement for this lesson is that you understand how to create macros in Access 2010, as discussed in the previous lesson. Otherwise, this lesson does not require any previous specific knowledge of macros or Access 2010.


Access 2010 has three types of macros: Macro database objects, Embedded Macros, and Data Macros. Though the differences between these types are somewhat minor, you should be aware of some important distinctions. This section discusses each type of macro and the key differences between the macro types.

Macro Database Objects

Macro database objects, often referred to as standalone macros, are the standard macro objects available in an Access database file. These macro objects are created when you choose the Macro option from the Create Ribbon. These macros are named and are called by name wherever their logic needs to be executed. The nice thing about standalone macros is that they are global to the database and can be called from anywhere that calling a macro is allowed, ...

Get Microsoft® Access® 2010 24-Hour Trainer now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.