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 14–18). 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.
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!
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 ...