• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Customizing Access > Creating a Macro

Creating a Macro

Before you begin creating a macro, you should plan the actions required to complete the tasks you want to automate. Practice the steps needed to carry out the operation and write them down as you go. Finally, test your written instructions by performing each of the steps yourself.

Create and Save a Macro

In the Database window, click Macros on the Objects bar.

Click the New button.

Click the Action list arrow, click the action you want to use, and then press Tab.

Type a comment if you want to explain the action.

Click the table name in the first Action Arguments box, click the list arrow, and then select a value.

To add more actions to the macro, click the right side of a new Action row, and repeat steps 2 through 5. The macro will carry out the actions in the order in which you list them.

Click the Save button on the toolbar.

Enter a descriptive macro name that helps identify the tasks the macro carries out.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint