Part II: Programming Microsoft Access
522
You’ll see many other examples that use ADO and DAO to manipulate data in Access tables and
recordsets throughout this book. A little bit of VBA code, coupled with either the ADO or DAO
syntax, is able to perform complex operations without the use of queries or other database objects.
Whenever possible, the examples in this book are written in a generic fashion that is easily modi-
fied to fit other situations by replacing the names of fields, tables, and other objects. You should
use VBA code whenever complex data-management tasks are required by your applications, or in
situations in which users require more flexibility than is provided by queries and forms alone.