Access 2003 In Pictures

  1. Open the Relationships window.
  2. Add the three tables: CDs, Artists, and Tracks.
  3. Link the Artist ID fields of the Artists and CDs tables.
  4. Accept the default options in the Create Relationship window.
  5. Link the Album ID field of the CDs table to the Album ID field in the Tracks table.
  6. Accept the default options in the Create Relationship window.

    When you're done, it should look like this:

  7. Close the Relationships window and save the changes.
  8. Exit Access.