O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Joins and Cascades

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required