One of the best tools when creating macros is the
Macro Design Toolbar. Here’s what it looks like:

And, here’s what each of its commands does:
|

|
Saves macros to the database. |
|

|
Search files. |
|

|
Print current macro definitions. |
|

|
Print preview current macro
definitions. |
|

|
Spell-check your macro definitions. |
|

|
Cut the selected text. |
|

|
Copy the selected text. |
|

|
Paste text in the current location. |
|

|
Undo your last action. |
|

|
Redo your last action. |
|

|
Toggle to Macro Names view. |
|

|
Toggles the Conditions field on or off. |
|

|
Insert a row. |
|

|
Delete a row. |
|

|
Run the current macro. |
|

|
View the current macro line by line. |
|

|
Build the current macro. |
|

|
View the database window. |
|

|
Create a new object. |
|

|
Open macro help. |