Cliceanne,
Macros are a tool to allow certain tasks, for example data management tasks,
or user interface manipulation tasks, to be automated.
In Access 2003 and earlier, click New from the Macros tab of the Database
Window. In Access 2007, click Macros from the Create ribbon.
You have a number of Actions from which you can choose from a drop-down list
of Actions. Most Actions have Arguments, which are completed in the section
at the bottom of the Macro design window. For example, there is an OpenForm
action, and then the name of the from to open is one of the Arguments.
Expressions can be entered in the Conditions column, to control whether
actions are activatd or not when the Macro runs.
Macros are then used by assigning them on an Event. There are many Events
which Access makes available for this purpose. The name of the macro is
entered into the Property sheet for an object on a form or report. One
example is the On Click event property of a Command Button.
In addition, a new feature of Access 2007 is the Embedded Macro, which
allows you to create a Macro directly into the Event Property.
In Access 2010, to be released next year, the Macro design process has been
hugely revised and enhanced, and Macros have become even more powerful, as
well as the introduction of a new type of macros called Data Macros.
It is a big topic, but hopefully this will help give you an idea. The Help
for macros in Access is very good.
