Chapter 6. Managing Data

Chapter 6. Managing Data

The point of a database program is to manage data. Although
Access provides most of the tools you'll need, there are many tasks for which
you have to roll your own solution. This chapter concentrates on working with
data in ways that traditional database operations don't support. You'll learn
how to search for records phonetically, back up your database objects, perform
lightning-fast finds on linked tables, save housekeeping information, and more.
All the examples in this chapter use some form of Visual Basic for Applications
(VBA) code, but don't worry梩hey are all clearly explained, and "testbed"
applications are supplied to show you how each technique works. We present more
tips for working with data in Chapter 14, focusing on techniques you can use
when your data is stored in SQL Server, rather than in an Access Jet database
(an .MDB or .MDE file).