O'Reilly logo

The Excel® Analyst's Guide to Access® by Michael Alexander

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

Appendix A. Access VBA Fundamentals

If you haven't worked much with VBA, you may want to brush up on some of the basics before tackling the later chapters in this book (Chapters 1418). The purpose of this appendix is to provide a high-level overview of some of the fundamental concepts and techniques demonstrated in the latter chapters. Bear in mind that because the focus of this book is data analysis, this appendix provides only an introductory look at VBA. If you are interested in an in-depth look at programming Access VBA, consider picking up one of the following titles:

Beginning Access 2007 VBA, by Denise Gosnell (ISBN: 0-470-04684-8)

Access 2007 VBA Programming For Dummies, by Alan Simpson (ISBN: 0-470-04653-8)

These books offer a solid introduction to VBA that is ideal for novice Access programmers.

Covering the Basics in 10 Steps

There is no better way to learn than hands-on experience. So instead of reading paragraph after paragraph of terms and definitions, you will cover some of the basics of VBA in 10 steps!

Step 1: Creating a Standard Module

Have you ever found code on the Internet that you could supposedly copy and paste into Access to do something wonderful, but you didn't know where to paste it? Well, knowing where to put your code is the first step in programming. In Access, VBA code is contained in a module.

Here are the types of modules you can use:

  • Standard Modules: This type is the most common, letting you store code you can use anywhere within your database.

  • Form and ...

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