Macros in MS Access

What is Macro?

MICRO means small, MACRO means large. Normally we are giving instructions to the computer ONE-BY-ONE only. For example, we double click on a table name. The computer opens the table. Then as a next instruction, we select the first record. Computer selects and show this by a black background. Then,we try to delete that record... Here there are 3 Micro instructions are given to the MS Access. Suppose, let us assume, such kind of work takes about 30 minutes. And , if you have to do the same kind of job almost daily, then you can create all the steps involved in one object called as macro and whenever you call this macro, it will do the whole job in just few seconds.

So, you meant to say that certain time-consuming routine works can be simplified. Is that right?

Exactly !

Apart from this any other advantage is there for Macro?

Suppose,you are going on one month leave from tomorrow. But who will run do this routine work? If macro is created, you can give instructions even to semi skilled staff, to just run this macro.

Can you show the steps for creating a simplest macro?

Yes. Let us create a Message Box. I hope this video given here explains the whole procedure.