Can you advise me with possible uses, benefits and limitations of Macros within Microsoft Access tasks?

If you sit in front of a computer screen all day creating reports in Microsoft Excel, you know the power of this software package. But if you aren't using macros yet, you don't know the half of it. Macros automate common and repetitive keystrokes that you use in Excel to create and edit spreadsheets. By reducing the number of keystrokes required to perform common commands, macros speed up your production and reduce the time you have to spend staring at an electronic spreadsheet each day

Macro Basics:

A macro is a term for a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task associated with those commands. Macros run in Microsoft Word, PowerPoint and Excel. Macros can be simple and complex and are created when you record a series of keystrokes using the macro dialogue box.

Macro Benefits:

Macros offer many advantages to those who choose to use them. They reduce the possibility of human error that increases with many, repetitive keystrokes and tasks. Macros reduce the amount of time that must be spent performing basic computing tasks, freeing users up for more complex problem-solving and idea-generating activities. They also make complex computations easier to perform.

>> posted Mohammed Yaseen

 

Lubna Thank you for posing this question.
Micros are wonderful in the sense that they are mini programs to do you task automatically.
These are written and used to carry out routine or special task which occur in your daily work repeatedly.
These are available in almost all applications of MSO family and the concept exists even outside the MSO and has been in existence for many years.
While writing a macro you should carefully watch all steps the micro executes.
It is likely that a micro may cause data corruption or simply deletion if one step somewhere is wrongly recorded.
So first take a backup of your database before trying out a new micro.
Always create a micro with clear steps in mind.
Test it under different situations and then commission it for routine use if it passes your testing.
Best of luck.

A macro is a name given to a block of C statements as a pre-processor directive.
Being a pre-processor, the block of code is communicated to the compiler before entering into the actual coding (main () function).
.
The advantage of using macro is the execution speed of the program fragment.
When the actual code snippet is to be used, it can be substituted by the name of the macro disadvantage of the macro is the size of the program.
The reason is, the pre-processor will replace all the macros in the program by its real definition prior to the compilation process of the program.

you have to get organized with the most useful templates created by Microsoft team on this URL http://office.microsoft.com/en-001/templates/?CTT=97, hope to finds you well and you can visit this site http://chandoo.org/forums/ and create an account to share on a very useful discussions related to perfect excel macros with a very perfect Excel Ninjas, i hope to find what you seek

When there are changing/volatile variables it will be difficult to run macros since it requires defining variables again & again

 

What are Macros in MS Access?

 

Macro is a set of ready-made procedures to perform one or more functions to do your repeated tasks

 

How can I use Macros in Microsoft Access?

 

In MS-Access 2007 above you can select [Create] tab then [Macro]

 

Then select needed procedure to do

 

{e.g. OpenReport => "Salaries" }  //Execute salaries report//

 

{e.g. RunMenuCommand => OutputToExcel } //Export report to MS-Excel for modifications//

 

What possible methods can I apply them in?

 

There is many ways to execute macro like:

 

-          Run it directly from [Database Tools] => [Run Macro] then select macro name that already created before.

 

-          Attach macro with event handler in forms and  reports.

 

-          Execute from VBA code.

 

-          Call macro from another one.

 

-          Select macro manually from navigation pane.

 

-          And more…

 

How can my Access work be effective after using macros?

 

Macro can work for you by storing a lot of procedures that you do every day / task and execute them to be completed in seconds.

 

What potential damage could be caused by using macros in MS Access?

 

Viruses and worms can store themselves into macro.

 

how can we avoid such trouble in their use?

 

When execute macro you must verify it before.

 

Don't receive macros from anybody you don't trust.

 

I agree with explanation given by .......@: Abdul Yaseen Mohammed