How to Create a Navigation Form in Access 2013
How to Run the Query Wizard in Access 2013
10 Things You Need to Know about Relationships 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
blog comments powered by Disqus
How to Import Data Sources in Access 2013
How to Start the Report Wizard in Access 2013
How to Create a Form that Appears When Access 2013 Opens
How to Create a New Access 2013 Form
Access 2013 For Dummies Cheat Sheet
Advertisement

Inside Dummies.com