Access 2007 also introduces embedded macros that are essentially properties of an object's event. In Access 2007, macros are significantly enhanced with the inclusion of error handling and temporary variable support. Macros can also contain sub-macros which are similar to subroutines. Macros support basic ‘IF condition’ logic and the ability to call other macros. Macros allow you to easily chain commands together such as running queries, importing or exporting data, opening and closing forms, previewing and printing reports, etc. If you do not have a programming background, you can use the macro feature to automate simple tasks through a series of drop down selections that Access has provided. The following Macro contains examples of: Visual Basic provides much more functionality than macros such as returning values or iterating through record sets. Using Visual Basic code rather than macros gives you much more flexibility and power. Over time, you’ll want to switch your Macro over to a VB code. Most professional Access developers use the VBA programming language for a richer and more powerful development environment. Luckily, you can use this function to develop prototype VBA code. Macros are not meant to be a permanent solution, and they take up more space than VB code.

Macros lack programming loops and advanced coding logic.

You might find yourself searching for some help developing a custom VB code. With some research, non-programmers can quickly set up a macro and dramatically increase database productivity. Macros can perform a number of the common tasks that you can also use Visual Basic code to perform. You do not need to know how to program to use macros! This feature can be used to add functionality or automate simple tasks, such as performing an action when the user clicks a command button. A macro is a stored series of commands that carry out an action or a string of actions.

Ms access macros