For other macros, you will need to specify when the macro will run. Our above example is a little bit different to most macros in that the name is what determines when it will run (it will run as soon as the database is opened).

You can also run macros by opening the Macros tab and double clicking on the macro you want to run (or selecting it and clicking Run from the Ribbon, or right-clicking it and selecting Run from the contextual menu).

To close the database, click the File tab from the Ribbon, then click Close. When we open it, the Customers form automatically opens and is ready for a new record to be entered. To do this we should close our database and open it again. Now that we've created our macro, let's test it. By naming it Autoexec, we are instructing Access to run this macro everytime we open the database. Click on the Save icon and enter a name for your macro. What we're doing here is ensuring that the form doesn't open up a previous record - it goes straight to the end and has a blank record ready for you to enter a new record (this saves time and unnecessary clicks): In the Record field, choose the record you want to go to - choose New. Use the dropdown menu to select your second action - choose GoToRecord.In the bottom pane, select the form name you wish to open - choose Customers Form (our only form):.Use the dropdown menu to select your first action - choose OpenForm:.Ensuring that the CREATE tab is selected from the Ribbon, click Macro:.Here's how you can go about creating a macro:

Doing this will save you from having to find the form, double-click on it, then click again in order to jump to a new record, every time you open the database. Macro Exampleįor example, if say 90% of your database usage is entering new customers into the Customers form, you could create a macro that automatically opens that form every time the database is opened, and jumps straight to a new record.

You could make a macro run when a user presses a certain key, or you could make a macro run everytime your database is opened. You specify what that event is when you create the macro. Macros are usually configured to run whenever a particular event occurs. A macro refers to a set of actions that can be run automatically, and on demand. Microsoft Access provides the ability for you to create macros.

You tube microsoft access 2013 tutorial