Access: Macro to create

In Access, you can combine it with a Macro several commands - such as the simultaneous opening and Printing a document. This saves you recurring tasks time. How can you create macros, you will learn in this practical tip.

The Macro Generator for Microsoft Access

The Macro-Generator will help you Create macros. The following guide works with all Access versions , starting in 2010.

To open the Macro Builder, click the Create tab, in the "" > "macros".
In the Macro Builder you will see at the right edge of the screen is the action catalog.
You can open the folder by Clicking on the black arrow or a double click.
You will now see the available actions. You move the mouse over a command, you will receive a detailed description of the respective function.
You are automatically in the design tab. Now you can use commands to create a Macro.

Create your macros in Access

To add the Macro to an action:

Navigate to the Macro-Generator for the action catalog on the right side of the screen.
Click on the arrow to the possible actions in the drop-down list.
The actions are clearly grouped according to categories. Expand the categories with double-click or click on the black arrow, so you can see all the actions.
Now select the action that you want to use. This is by Clicking or dragging the command to Drag and Drop in the Macro window.
The Macro for more actions, go to the next line and select another command.
Some actions may require sub-commands or arguments. For example, select "Run menu command", you need to call Access, then select the desired menu item. This is done very easily via a selection menu, which appears in the connection.
You have integrated all of the desired commands in the Macro, click in the toolbar for quick access to Save.
Now enter a descriptive name for the Macro, and confirm with "OK".
You start your Macro to test it.
To do this, navigate in the tab "design" in the ribbon menu the command "Run" or click in the left window, "All Access objects" with the right mouse button on the desired Macro. Then select also "Run".
If you start a Macro, Access runs the actions in the order they are entered.
You can change the order at any time by moving the actions with the green arrows located at the right edge of the Macro-command window up or down.