Chapter 4. Working with Access Databases and Tables

The traditional definition of a database is a collection of related data items stored in an organized manner. Access is unique among desktop database development applications for the PC because of its all-encompassing database file structure. A single Access .mdb file can contain data objects—tables, indexes, and queries—as well as application objects—forms, reports, macros, and Access Visual Basic for Applications (VBA) code modules. Thus, you can create a complete Access database application stored in a single .mdb file. Most Access developers use two .mdb files: one to contain data objects and one to hold application objects.

This chapter and Chapter 24, "Securing Multiuser Network Applications," ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.