Introduction :
A Database continues to grow with time. You add new records perform carries and print report, you realize that you need to perform most of the task repetitively. Four examples, you open the same form for data entry and run reports. Instead performing the same steps every time, you can automatic the processing by using macros.
Macros :
Macros are small programs that perform a specified task every time they are run. A Macro (a action horror set of action that you can use to automatic task) is a set of one or more actios (the basis building block of a micro a self contained instructions that can be combined with other action to automatic tasks) that is performs a particular operations, such as opening a phone for printing a report. Micro can help you to automatic common report then I user clicks a command button.
Or
You can create macro to open a data entry form. After the data entry is over the macro can run carry based on the data entered.
Every task you want to perform is called an action. You can have maximum of 999 action s in a micro.
You can use macro for any repetitive task you do in access.
You can use macros to perform tasks together.
Open multiple forms or reports.
Check for data redundancy. For example you can run find unmatched query.
Mom daughter between fields.
Elements of Macro : The Four Elements Macro One of Which is Optional Are
The event: the reason the macro fires or trips. Some events examples Ara form control gaining or losing focus, a mouse cursor moving aver and area, a keystroke or form load.
The Action Argument :
What specifics the action applies to. For example when you use access to create a macro date opens the form for data entry. The action is to open a form whereas the property of that is data entry form. Conditions: you can program your macros 25 run only when cretain condition exist. The conditional capability of macro is considerably less developed.