| Lesson 3 | Creating an Access macro by using the Macro Builder |
| Objective | Use the Access Macro Builder to create and run an Access macro. |
Creating Access Macro using Macro Builder
Now that you have some idea of where Access macros are used, let us take a look at how they are created by using the Macro Builder.
First, let us take a look at this MouseOver of the Access Macro Builder, showing you how to open the Clients form by using a macro.
- This is where you type the name of the macro.
- This is a list of macro Actions from which you can select.
- This column is used for documenting your macros. By documenting your macros you can remember what the purpose was for the macro and also help others who have to help maintain the macro
- Action Arguments specify the parameters used with each action. They will change based on the Action you choose.
Access Macro Builder
To create a new macro in Access, follow the steps below:
To create a new macro in Access, follow the steps below:
- Click the Macros list in the Database window.
- Click the New button. You will be presented with a blank Macro Builder.
- Specify the Macro Name.
- Pick the Macro Action to perform.
- Type in a comment to document your macro.
- Fill in the Action Arguments.
There are 54 possible macro actions that you can use, which allow you to automate transferring objects back and forth between your database and another Access database or file format.
For help on any of the actions select the item from the list and press F1.
In the next lesson, you will learn how to assign a macro to a command button on a form by using the OnClick event of a command button.
In the next lesson, you will learn how to assign a macro to a command button on a form by using the OnClick event of a command button.
Message Boxes Forms Macro
Click the link below to practice creating a macro that displays a message box then opens a form.
Message Boxes Forms Macro
Message Boxes Forms Macro