(An action is an instruction that directs Access to perform a specific act, such as selecting an option from a menu.) Table 18-1 lists the different macro actions available.Īdds a drop-down menu to a menu bar. Access has 53 macro actions you can pass values (called arguments) to a macro action to control the operations the action performs. When you record and then execute a macro, the macro typically mimics the steps a user would take when manually using a program.Īccess also has a macro language you can use. For example, both Word and Excel include macro languages you can use to automate a series of commands. Macros let you program your software without requiring you to learn or even understand the basics of writing a program. Macros help you automate tasks within a program such as Access. In general, a macro is nothing but a series of commands an application program executes. You have probably heard the term 'macro' before.

How to link a macro to a command button on a form.What it means to create conditional macros.What macros are and how you can use them.As you will learn, you can write macros that perform simple or complex tasks.īy the time you finish this chapter, you will understand the following key concepts: Later, you can play back your macro and Access will automatically perform the steps for you. Using an Access macro, you record these steps. In short, a macro is a recording of the steps you perform to accomplish a specific task.įor example, to print a table, you select the File menu Print option and then choose OK within the Print dialog box. One of the ways Access lets you simplify tasks is with macros. As you work more with Access, you will discover many ways you can tailor your Access environment to your needs.

Ms access macros