Chapter 1 explored sound database design principles. You learned that you might need to break up a large table into smaller tables for better efficiency and data integrity. This chapter focuses more on the relationships between tables. To properly understand the way Access handles relationships between tables, you need to understand joins and cascades. To be more specific, you learn
what joins are and why you should use them
what referential integrity is
what cascading updates and deletes are
how to define referential integrity and cascades in the Relationships window
What are joins and why use them? Before these questions can be answered, you need to understand where to use them. The primary places in Access that ...