a macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls. for example, if you add a command button to a form, you associate the button's onclick event to a macro, and the macro contains the commands that you want the button to perform each time it is clicked.