Access 2007

Building Table Relationships

5 of 5

Challenge!

If you haven't already done so, save the sample Ready2Read database on your own computer.


  • Open the database and establish a relationship between the Books table and the Orders table using the Drag and Drop method.
  • Establish a relationship between the Customers table and the Orders table using the Edit Relationships command on the Ribbon.
  • Edit an established relationship by double-clicking the link.
  • Explore the options and settings in the Edit Relationships dialog box.
  • Move the tables around in the relationship map.