What types of applications most benefit from the use of macros?
Single-user or small departmental applications most benefit from the use of macros.
What are some of the main limitations of macros?
You cannot include error handling, user-defined functions, variables, parameters, OLE automation, DDE, transaction processing, or Windows API functions within macros. Macros do not allow you to process table records a row at a time or create database objects at runtime. It is also much more difficult to debug macros than it is to debug VBA code.
What is the purpose of the Macro Names column of a macro?
The Macro Names column allows you to place multiple routines in one macro.