our approach|new tutorials|contact us

Access 2007 In Pictures

• Database Basics
• Working with Tables
• Working with Forms
• Working with Queries
• Working with Reports

14. Open the Relationships window.
15. Add the three tables: CDs, Artists, and Tracks.
16. Link the Artist ID fields of the Artists and CDs tables.
17. Accept the default options in the Create Relationship window.
18. Link the Album ID field of the CDs table to the Album ID field in the Tracks table.
19. Accept the default options in the Create Relationship window.
    When you're done, it should look like this:

    

20. Close the Relationships window and save the changes.
21. Exit Access.