Access VBA Programming for Dummies

Welcome to Access VBA Programming For Dummies. As you (hopefully) already know, Microsoft Access is a huge database management program, offering lots of ways to manage data (information). Common uses of Access include managing mailing lists, memberships, scientific and statistical data, an entire small business, and just about anything else that involves storing and managing large amounts of information.

As the title implies, this is a book about using Visual Basic for Applications (VBA) to enhance the power of Access databases. It’s not a book about creating Access tables, queries, forms, reports, and such. To stay focused on VBA, I need to assume that you already know all that. Furthermore, there’s really no point in even using VBA until you’ve already created a database with at least some tables and forms in it. In fact, writing VBA code is usually the last step in creating a custom Access database.

Unlike other programming books that you might have seen, this one doesn’t assume that you’re already a programmer. I don’t even assume that you’re already an accomplished programmer who is just picking up a new programming language. Rather, I assume that you’ve never written any programming code in your life — and maybe aren’t even all that sure what programming code means or how it relates to Microsoft Access.

By the time you finish this book, you’ll know exactly what VBA is all about and you’ll know how it fits into Access. You’ll discover the meanings of all those obscure terms that programmers throw around — code, variable, array, loop, object — as though they were common knowledge. You’ll be able to write and use your own custom code, just like programmers do.

You might have noticed there is no version number in this book’s title: That is, it’s not Access 2002 VBA or Access 2003 VBA. Here’s why: Although many changes and improvements to Access have occurred in all the versions that Microsoft has released, the VBA programming language has hardly changed a bit over the years. The code that you see here should work as-is in Access 2000, 2002, 2003, and any subsequent versions released. The vast majority of the code in this book will also work just fine even in last century’s versions, such as Access 97.

Download Access VBA Programming for Dummies (8.01 MB, 410 pages)