O'Reilly logo

Microsoft® Access VBA Programming for the Absolute Beginner by Michael Vine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 12MACROS AND PERFORMANCE TUNING

In this chapter you learn about macro objects in Access 2010, including how to create and debug stand-alone macros, and convert macros to VBA code. You’ll also learn about form, VBA code, query, and index performance considerations to build a well-tuned Access database application. I will also show you how to leverage out-of-the box database optimization hints through Access’s Performance Analyzer.

MACROS

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required