How to Import Data Sources in Access 2013
How to Run the Query Wizard in Access 2013
How to Start the Report Wizard in Access 2013

How to Set Table Relationships in Access 2013

For each pair of tables you want in the relationship, click the table and then click Add.

In the big Relationships workspace, a little window lists the fields in the selected table. As you add tables to the layout, a separate window appears for each table. You can see these windows to the left of the Show Table dialog box.

Repeat Step 2 for each pair of tables you want to relate. If one of the tables in the pair is already present (due to an existing relationship it has with another table), you don’t have to add it again.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
How to Create a Navigation Form in Access 2013
10 Things You Need to Know about Relationships in Access 2013
How to Convert an Older-Version Access Database to Access 2013
Access 2013 All-In-One For Dummies Cheat Sheet
How to Create a New Access 2013 Form