Reader Level:
Article
Microsoft Office

Macros Operations in Access 2013

By Richa Garg on Aug 27 2012
In this article I will explain how to create a macro in Access 2013.
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 22.5k
  • 0

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.