• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part I: Tables and Queries > Joins and Cascades

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint