【 Create Data Macro in Access 】 Step by Step Guide ▷ 2022

macros have become one of the most recent functions added to it allows execute an action just before or just after adding, removing, or updating data from a . Therefore, it has become a tool very useful when working on this program.

It is important to mention that working with macros is not an easy tasksince it usually has its complicationsbut once you manage to apply them you will notice all the benefits that this option can give youespecially when you are working with a quite extensive database.

In accordance with this and the importance of power manage all the tools that this software offershere we are going to show you how you can start create your own data in an Access table from scratch, To do this, follow in detail everything that we will teach you below.

What are data macros and what are they for in Microsoft Access?

The data macros are became one of the new features of Microsoft Access 2010, They are intended to allow run tasks before or after performing an action on a table. In the same way it allows to apply a little logic to events that occur inside tables, as is adding, deleting or updating data. In this way, it can be said that macros are managed from the table tab.

While viewing a table in a datasheet view and macros They do not appear in the option “Macros”. And it is that this tool allows you to carry out different actions such as validating the data in a table and checking their accuracy. You can currently find two main data macrosthe first of which deals with handle table events and those that are executed as responses to the be called by name they are also known as named data macro.

Learn step by step how to create a data macro in Microsoft Access

Taking into account everything mentioned above in the post and knowing What are data macros and what are they for?the next thing will be to show you step by step how you can start create them in Access. This process can be done in two ways, either from event macros and named data macros.

To do this, follow each of the methods that we are going to teach you below:

event driven

The first method that we will teach you is about event data macrosin this case the table events they end up being produced every time add, delete, or update data in a table. So here you can program a macro so that it is adjusted immediately once any of these events occurs events or once a modification or deletion event is carried out.

In order to create a macro named by events, you simply have to follow each of the steps that we will teach you below:

In the access navigation bar you must double click on the table where you want add the data macro.
Now in the group “Previous Events” either “Later Events” Depending on the case, you must select the event in which you want to add the macro. In case you want add a macro that runs after remove any record from the tablethen you must select the option “After delete.”

In this case Access starts the macro builderin the event that one has previously been created for said event, then the system will show you a notice indicating that there is already an existing one.
then you must add the actions what do you want me to know run through the macro.
Finally, you must save the action and close the macro for it to be applied at the time.

Name Data Macro

The process for create these names data macro is easier and faster to perform, they are associated with a specific table and not with a specific event as in the previous case. In this case you can call a named data macro from any other data macro or standard macro.

In addition, the process of creating it is easier, for this follow each of the following steps:

In the navigation pane you must click on the table you want add the named data macro to it.
Now in the tab “Table” and in the section “Macros with names” you must select the option “Named Macros” and then “Create named macro”.

The window of the “Macro Generator” so you can start add the corresponding actions.

Steps to manage the data macros you create in Microsoft Access

In this case, the only important thing is not to know how to create thembut also how to manage them. And it is that the data macros usually do not appear in the macro Navigation Pane, This means that you must use the commands of the “” that are in datasheet view the table or in the design view. This allows create, edit, rename, and delete macros as needed.

In accordance with all this, here we are going to teach you how to manage macros in Microsoft Access, for this, follow each of the methods that we will teach you below:

Edit event macro

The first method that we teach you is that of Manage event macros.

To do this, you need to follow each of these steps:

The first thing will be to select the table that contains the data macro that you want to editin this case that of events.
Now in the tab “Table” you will find the sections of “Previous Events” either “Later Events”, there you must select the event of the macro you want to edit. In this case you can select the edition of the macro that is executed after deleting a record from the tableTo do this, click on the option “After delete.”
It will automatically start the “Macro Generator” and there then start editing the macro you have selected.

Edit naming macro

To edit the name macros you will simply have to execute each of the steps that we will indicate below:

Here you must click on the table to be able to open it in the datasheet view.
Now in the tab “Table” you should go to the section “Named Macros” and there select the option “named macro”, In the options that appear there you must select the option “Edit Named Macro”.

Then in the submenu you must click on the data macro you want to edit.
It will automatically start “Macro Generator” so that you can start editing the macro you have selected.

Modify macro name

Another aspect that you can modify is the name of the macro.

To do this you must perform these steps:

To carry out this procedure you must go to the navigation pane and there double click on any of the tables to open it in datasheet view,
Again you must go to the file “Table” and there select the option “Macro named” from the section of “Named macro”.
In the options that appear there you must select “Rename/Delete Macro”.

Then the dialog box will appear “Data Macro Manager”there you must select the option “Rename” located right next to the macro you want to rename.
Here you must write the new name you want to give itand once it is defined you must click on “To accept”.

delete a macro

Finally, we are going to explain how can you remove a macrokeep in mind that this process is completely similar to the one mentioned above.

To do this, follow these steps:

Again you must access the tab “Table” and there go to the section of “Named Macros” and select the option “Macros with names”.
In the drop-down menu that appears there you must select the option of “Rename/Delete Macro”.

The box will automatically start “Data Macro Manager” this time you must click on the option “Remove” which will be found right next to the macro you want to remove.