The macro design editor includes a simple drop-down menu of actions to choose from. Upon selection, the action expands to display the required arguments needed to customize the macro for the specifics of the database. In this video, Adam walks through the macro design interface and gives tips to creating the first macro.
- [Instructor] Access macros can accomplish…a wide range of tasks and become even more powerful…when you string together a series of actions in a sequence.…Let's get started by taking a look at the macro designer…and see what actions we have at our disposal.…To do that, I'll come up here to the create tab,…and on the far right, in the macros and code group,…I'm going to click on the macro button.…This'll open it up in design view.…Now, the first thing to notice is that there's only one…contextual tab for macros, called design.…Also notice, on the left, that there's no view button,…we just have this one button, called run.…
If I switch over to the home tab, you'll notice that…the view button there is grayed out and inaccessible.…So macros only have the one view,…and that's the design view.…Let's go back to the design tab.…The main portion of the interface…has a simple dropdown menu.…This will display all the actions you can choose from…for your macro to perform.…At the top are a couple of program flow components,…
- Creating multi-step macros
- Triggering macros
- Running macros at startup
- Adjusting the execution and flow of macros
- Troubleshooting macros