Microsoft® Access® 2010 24-Hour Trainer

36

Embedded Macros in Forms

Macros is one of the major Microsoft Access features that has been greatly improved upon in the last several releases of the product. Access 2010 has a completely revamped Macro Designer that makes it easier than ever to create macros in a database application. Using macros can be extremely easy, especially considering you do not need to know any special code to make them work. Using macros in forms can be a very simple, yet extremely effective method for enhancing the functionality of forms in an Access database.

LESSON SETUP

This lesson provides an overview of working with embedded macros in Access Forms. Now that you have a basic understanding of working with Access Forms and the controls that can be used on them, you explore the building of some embedded macros in a form to show how easy it is to build macros for forms using Access 2010.

MACROS IN ACCESS

The term macro in Access refers to a type of functionality that can be executed when the macro is called. A macro can have one or more actions that execute in sequence. The best part about them is that building macros is as easy as choosing items from a list, like in the Property Sheet. Basically two types of macros can be used in forms: Named Macros and Embedded Macros. These types of macros are basically the same, with a few distinct differences.

Named Macros

Named Macros, also known as standalone macros, are created as database objects. This is really the base type of macro object. A Named Macro ...