What is the difference between a stand alone macro and an embedded macro?

What is a stand alone macro?

Standalone macros in Access are programs you create in a visual environment. In Access, standalone macros run a series of actions in a specified order. Unlike embedded macros, standalone macros in Access appear as separate objects under the “Macros” category in the database's Navigation Pane.

What is an embedded macro?

An embedded macro is a macro that is not displayed in the Navigation Pane under Macros; it is stored in the event properties of forms, reports, or controls. This can make your Access database easier to manage because you don't need to monitor separate macro objects that contain macros for a form or a report.

How do I find an embedded macro in Access?

In Access 2010, go to the Create tab on the ribbon. Click Macro. An "Action Catalog" panel should appear on the right side of the screen. Underneath, there's a section titled "In This Database." Clicking on one of the macro names should display its code.

How do I create a standalone macro in Access?

Create a standalone macro1On the Create tab, in the Macros & Code group, click Macro. Access opens the Macro Builder.2On the Quick Access Toolbar, click Save.3In the Save As dialog box, type a name for the macro, and then click OK.4Continue with the section Add actions to a macro.