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).
To add a macro to a form in Access 2013 or 2016:
- Create a macro
- Now, open the form in Design view
- Click the Button icon in the Ribbon (from the DESIGN tab)
- 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
- Select the name of the macro you want to run and click Next
- Choose whether to display text or an image on the button and click Next
- Give the button a name and click Finish
To create a macro in Microsoft Access 2013 or 2016:
- Click Macro from the CREATE tab
- Add actions by selecting an action from the combo box
- Customise the actions if required
- Repeat steps 2 and 3 for each action you want to add
- Save the macro