A macro helps you perform routine tasks by automating them, for example, instead of clicking the Reports tab in the database window, finding and opening a specific report, printing it and then closing it, you could create a macro to print the report with the click of a single button.
In some programs such as Microsoft Excel, it is possible to record a macro using the Macro Recorder.
A Macro is a way of programming Access to perform repetitive tasks automatically. Macros can be used to open forms, maximise them and produce welcome messages or can perform complex calculations and controls on selected data.
Most of the time, you will want to attach a macro to a form or form object to control the way the form or object work –
often to insert standard text, work out conditions e.g. If the town is Edinburgh then the district must be Lothian, and so on.