Step 5: Next the users need to specify, which form they would like to display when the command button is selected in the form.

Users can select the action they would like to automate on their form from the Categories and the Actions list.

Step 4: A Command Button Wizard will appear on the screen.

Step 3: Now go to Design View, add the button using the Control menu.

The user can add button in the form which directs them to the job or salary information.

Step 2: Say you have opened an Employee form.

Step 1: Open any Database and select a form in which you want to add a Macro command.

Here is an example for creating a simple Micro which opens the form whenever the user clicks the command button. Steps for Automating tasks in MS Access with the use of Macros

Users can also use Marcos to run commands without writing or having the knowledge of VBA code.

Once the user has created database objects like forms, reports, and tables, Macros can offer an easy and quick way to tie these objects together and create a database application which can be accessed and modified by anyone, with just basic relativity training.

Macros can also act as standalone objects which can be embedded directly in a Report or a form or can be viewed from Navigation Pane.

Access Macros is built with a set of default predefined actions, which offer automating tasks and an option to add functionality in objects and controls.

In Access, one can create Macros with which a user is able to record series of Keystrokes and can play them in the future. Access’s Macros work a little differently from Word and Excel yet are equally powerful. Marco is an MS Access feature which allows users to automate tasks while adding functionalities in their reports, forms, and controls. This article addresses how users can set up Automation tasks in MS Access with the use of Macros.

Ms access macros