A macro is a series of automated steps, such as opening a report or form or displaying a message box that you create and save. After you save the macro, you can run it whenever you want, either by right-clicking it and clicking the Run option, or by running it when something specific happens, such as clicking a button on a form. If you export Access tables to other formats, print records, or search for records and are tired of going through the process manually, you can create a macro that does it for you.
Click the Create tab.
Click the top part of the Macro button.
Click the down arrow in the first Action cell.