How to Create a Macro in Microsoft Access

Macros are a set of instructions preprogrammed into a software application that can automatically or on command perform certain tasks for the user. Microsoft Access tables can feature macros that perform a number of functions that a user would normally have to perform manually, such as opening new tables, creating hyperlinks or importing data. Creating a macro in Access doesn't require any prior knowledge of computer programming; the application has a macro wizard that walks you through the process.

Instructions

1. Open a new or existing table in Microsoft Access.

2. Click the "New Object" tab on the menu bar and choose "Macro." Click "New."

3. Click the arrow in the Action column to open the action menu. Click on the action that you want the macro to perform.

4. Type in a name for the macro action in the lower informational pane that has opened. If you are creating an action macro, you will be asked to choose various commands depending on the macro's intended target object from a pull-down menu. Instructions and tips for assigning macro commands will appear in the right-hand side of the pane.

5. Type in any comments regarding the macro that you have created in the "Comment" column.

6. Create another macro by clicking on the next row in the "Action" column and repeating the steps.

7. Click the red "X" located on the top right-hand corner of the macro box when you have finished creating the macro. Click "Yes" when asked if you want to save the macro you created. Type in a name for the macro and click "OK" to return to the Access table.