microsoft access 2013 tutorial 5 review assignment supplier

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.

Microsoft access 2013 tutorial 5 review assignment supplier