Read over these

Access 2007: The Missing Manual, 1st Edition
  1. In Access 2007: The Missing Manual, 1st Edition,
    read 5. Linking Tables with Relationships.
  2. Guide to table relationships
  3. It wouldn't hurt to read the Wikipedia entry on Foreign key for background.
  4. Read this linked article again
    • you already read it prior to the first relational database session to have an idea about why relational databases are useful
    • now read it again after pondering the lecture on tables
    • in the - next session we will discuss how and why to relate tables and we will create relationships between them

[top]