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.