Integrating Objects and Relational Databases
This chapter takes a step back and starts with the definition of data objects and how you identify them. Because Access is an object-enabled database development tool, the concepts of database design presented in this chapter have an object-oriented bent. The reason for this approach is twofold:
Access's relational tables incorporate many of the features of client/server databases. Properties, such as validation rules and indexes, and methods, that include preventing duplicate primary key entries, are combined in the table object. Details of relationships between tables and methods of enforcing referential integrity are stored in the database object.
Access VBA treats the database itself and each of ...
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.
