Normalizing Data to the Relational Model

Up to this point, most of the subject matter in this chapter has been applicable to any type of database—hierarchical, relational, or even the new class of object database systems. However, because Access is a RDBMS, the balance of the chapter is devoted to relational databases. Access fully implements the relational model in its native database structure and you can link tables from other RDBMSs—including client/server tables—to Access databases. Thus, the discussion that follows is general in nature and applies to any database system with which Access is compatible or for which you have the appropriate 32-bit Open Database Connectivity (ODBC) driver. (Access 97 requires the use of 32-bit ODBC drivers.) ...

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.