Macros Operations in Access 2013

Introduction

In this article I will explain how to add or create a macro in Access 2013, and how to create the parameters in a macro and various other operations in macros using Access 2013. To see how they work, let's use the following steps.

Step 1

Open Access 2013 and then select blank page and give the name of your database that you want to give.

CreateDatabaseIn2013.jpg

Step 2

Now go to the Table menu and click on the arrow on the Named Macro, as:

SelectMacroInAccess2013.jpg

Step 3

A pop up menu is shown, from this select Create named macro as:

CreateMacroInAccess2013.jpg

Step 4

A macro window will open which looks like:

MacroScreenInAccess2013.jpg

Step 5

Now click on the Create parameter link to create the parameter as:

AddParameterInMacroUsingAccess2013.jpg

Step 6

Now add some parameters and their description as:

ListOfParametersInAccess2013.jpg

Step 7

Now apply these parameters in the action; first select the if condition from the Add New Action dropdown list as:

IfConditionInMacroUsingAccess2013.jpg

Step 8

Give the condition in the if statement and then the structure of the if condition looks like:

MacroOperationInAccess2013.jpg

Step 9

Select comment from both the if-else action and give the comment, after that the macro will look like:

CommentsInMacroUsingAccess2013.jpg

Step 10

Now save your macro and use it in your table by attaching it in a table.


Similar Articles