SECTION 1
Lesson 1.5: Advanced Macro Uses

   

 

 

1.

Open Microsoft Access 2003.

 

 

2.

Open 1-5 Sample from the Exercise Files folder.

 

 

 

3.

We’ve created a new macro for you. Let’s open it with the Visual Basic Editor.

Switch to the database window and click Macros.

Select Macro 1.

 

 

 

4.

Click the Tools menu, click Macro, and click Visual Basic Editor.

 

 

 

5.

The Visual Basic Editor will open. Feel free to click through the menus and the options; close the editor when you are done.

 

 

 

6.

Drag the Macro Group to any spot on the toolbar.

 

 

 

7.

Now, click Macro 1 and click Design.

 

 

 

8.

Click the Macro Names button () on the Macro Design toolbar.

Enter ^q for the Macro Name.

 

 

 

9.

Click the File menu and click Save As.

Name the macro AutoKeys.

Click OK.

 

 

 

10.

Close the macro window.

Using the database window, switch to Contacts Form view.

 

 

 

11.

Press Ctrl and Q and see what happens.

 

 

 

12.

Save your database as 1-5 Completed.

 

 

 

13.

Close Microsoft Access 2003.