Customizing Access

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.

Create a Macro

  1. Click the Create tab.

  2. Click the top part of the Macro button.

  3. Click the down arrow in the first Action cell.

  4. Click the desired action.

  5. Fill in the arguments for the action. The arguments you can set will be different for every action.

    1. Repeat Steps 3 through 5 on subsequent table rows to add actions to your macro.

  6. On the Quick Access Toolbar, click the Save button.

  7. In the Save As dialog box that appears, type a name for your macro.

  8. Click OK.

    Create a Macro
    Create a Macro
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset