Part II. Programming Microsoft Access

IN THIS PART

Part II explains the art and science of Visual Basic for Applications (VBA) and introduces macro programming. Very few professional-quality Access applications have been written without liberal use of either the VBA programming language or macros, or a combination of both. VBA provides you with powerful tools for adding capabilities and flexibility to your applications.

As you'll see in this part, VBA is a large and somewhat complex programming language. If you aren't already using VBA, you'll want to carefully study the chapters in this part and work the examples until you're comfortable creating VBA modules and composing programming statements.

These chapters provide you with the essential skills necessary to become comfortable writing VBA code. You'll learn where VBA code lives within an Access application, how to compose VBA statements, and how to hook up VBA code to your forms and reports.

It's hard to exaggerate how important VBA programming skills are to professional database developers. Because VBA is used in so many different platforms (Access, Word, Excel, and more), your programming skills are transferable to many situations beyond Access database development. Also, the VBA programming language ...

Get Access® 2010 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.