Microsoft Access 2010 Bible

Part II

Programming

Microsoft Access

IN THIS PART

Chapter 10

VBA Programming Fundamentals

Chapter 11

Mastering VBA Data Types and

Procedures

Chapter 12

The Access Event Model

Chapter 13

Accessing Data with VBA Code

Chapter 14

Debugging Your Access

Applications

Chapter 15

Using Access Data Macros

P

art II explains the art and science of Visual Basic for

Applications (VBA) and introduces macro program-

ming. Very few professional-quality Access applica-

tions 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 com-

plex 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 neces-

sary 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 is very similar to the

languages used in Microsoft Visual Studio. Quite frankly,

there is no limit to what you can accomplish with the skills

you develop in learning Access VBA.

14_475348-pp02.indd 37514_475348-pp02.indd 375 4/1/10 1:46 PM4/1/10 1:46 PM