Microsoft Office® Access 2007 Inside Out

Chapter 20. Automating Your Application with Visual Basic

Why Aren’t We Using Macros?

Assisting Data Entry

Validating Complex Data

Controlling Tabbing on a Multiple-Page Form

Automating Data Selection

Linking to Related Data in Another Form or Report

Automating Complex Tasks

Automating Reports

Now that you’ve learned the fundamentals of using Microsoft Visual Basic, it’s time to put this knowledge into practice. In this chapter, you’ll learn how to create the Visual Basic code you need to automate many common tasks.

You can find dozens of examples of automation in the Conrad Systems Contacts, Housing Reservations, and Wedding List sample databases. As you explore the databases, whenever you see something interesting, open the form or report in ...