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

Chapter 19. Taking Advantage of Database... > Reviewing Table Relationships

Reviewing Table Relationships

When we first discussed creating a database in the Access section of this book, we made a case for creating tables that held discrete subsets of the data that would make up the database. We then discussed the importance of creating relationships between these tables in Lesson 9, “Creating Relationships Between Tables.” In this lesson, you take a look at how you can take advantage of related tables when creating other Access objects, such as forms, queries, and reports.

As previously discussed in Lessons 1 and 9, tables are related by a field that is common to each table. The common field serves as the primary key in one of the tables and as the foreign key in the other table. (The foreign key is the same field, but it is held in a table where it does not serve as the primary key.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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