Tag: macros

Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros

This article is Part 3 of the Microsoft Access tutorial.

Here’s what’s included in this article:

  • Create a query (so you can “search the database”).
  • Create a form for data entry.
  • Create a macro (so that a multi-step task can be done automatically – at the click of a button).

Continue reading

How to Add a Macro Button to a Form in Access

To add a macro to a form in Access 2013 or 2016:

  1. Create a macro
  2. Now, open the form in Design view
  3. Click the Button icon in the Ribbon (from the DESIGN tab)
  4. In the Form Detail area, click and drag the cursor so that it forms a square or rectangle (i.e. shape of a button). The Command Button Wizard will pop up. Select Miscellaneous > Run Macro and click Next
  5. Select the name of the macro you want to run and click Next
  6. Choose whether to display text or an image on the button and click Next
  7. Give the button a name and click Finish

Continue reading

How to Create a Macro in Access

To create a macro in Microsoft Access 2013 or 2016:

  1. Click Macro from the CREATE tab
  2. Add actions by selecting an action from the combo box
  3. Customise the actions if required
  4. Repeat steps 2 and 3 for each action you want to add
  5. Save the macro

Continue reading

© 2018 Database.Guide

Theme by Anders NorenUp ↑