Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Macros are Access objects that you build and assign to form, report, or control events to automate tasks and processes without VBA programming. Macros hide the implementation details of the VBA programming language much like a class definition encapsulates the complexities of an object’s functionality. For example, you can create a macro to open a query when a user clicks a command button on a form by associating the macro name to the command button’s On Click event property.
VBA is incompatible with SharePoint Access services. If you plan to publish your Access 2010 database to a SharePoint server running Access services, macros must be used for programming responsibilities instead of VBA.
Access 2010 has added and enhanced many macro features including: