Chapter 9. Creating Relationships
Relational database design principles
The types of relationships available
Establishing referential integrity
Introduction to Relational Database Design
Many people believe Access is such a simple product to use that database design is something they don't need to worry about. I couldn't disagree more! Just as a poorly planned vacation will generally not be very much fun, a database with poorly designed tables and relationships will fail to meet the needs of its users.
The History of Relational Database Design
You should be happy to learn that, although Microsoft Access is not a perfect application ...