Databases : Macros

A macro is a short sequence of instructions that will automate a task. People who make databases often create macros to simplify the use of a database.

A macro in a database is a short sequence of instructions that the database will carry out. Writing a macro is like writing a program in a high level language. The user writes the instructions that will carry out the actions required of the macro. Common tasks that macros are used to perform in a database include opening and closing forms, printing reports and running queries.

Once a macro has been written it must be saved. The macro can then be executed (or run) whenever the user requires it. Often macros are associated with buttons on forms so that when a button is pressed a particular macro is excecuted.

GCSE ICT Companion 04 - (C) P Meakin 2004