Creating A Macro In Microsoft Office Access

1) Creating A Macro

2) Macro User-Interface

3) Hiding Objects Panel

4) Adding a command

5) Command and Arguments

6) Running A Macro

7) Closing Macro Window

8) Finding Macro Object in Objects Panel

1) Creating A Macro

1. Click Create Tab
2. Click Macro Button

2) Macro User-Interface

3) Hiding Objects Panel

3.1) Click the close icon on top right of Objects Panel to close the panel and give more space to Macro Editor Panel

4) Adding a command

1. Click the drop-down button and select MessageBox

2. Outcome:

5) Command and Arguments

5.1) Type “Hello World!” in the Message field.

5.2) Set Type field to Information.

5.3) Type “Our first message”

6) Running A Macro

6.1) Click the Run button.

6.2) You may be prompted to save your macro first.

6.3) Save it as “mcrHelloWorld”

6.4) Outcome:

7) Closing Macro Window

7.1) Look at the top right corner of the Macro Editor panel.

Click the close button.

(Notice that you will see the “Close ‘mcrHelloWorld’” when your mouse hovers the right close button)

8) Finding Macro Object in Objects Panel

8.1) You can find the Macro “mcrHelloWorld” under the title “Macros” in the Objects Panel.