Reader Level:

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.


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.


Step 2

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


Step 3

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


Step 4

A macro window will open which looks like:


Step 5

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


Step 6

Now add some parameters and their description as:


Step 7

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


Step 8

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


Step 9

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


Step 10

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

Richa Garg
Richa Garg

I am a Junior Software Developer In MCN Solutions Pvt. ltd. and very much interested in .net technology :, C#, WPF,  SQL Server, Windows Store apps, HTML, DHTML, CSS etc......



Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.

Trending up