GCFLearnFree.org

I love you guys!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2007
  • Building Table Relationships

Access 2007

Single page view print copy

Building Table Relationships

Building Table Relationships

Watch the video! (6:10min)

Download the example to work along with the video.

Establishing relationships

To establish a relationship between tables:

  • Click the Relationships command in the Show/Hide group on the Database Tools tab in the Ribbon.

    NOTE: Tables must be closed in order to establish relationships.


    Relationships CommandRelationships Command
  • When the Show Table dialog box appears:
    • Select each table name, then click Add for the tables you want to relate.
    • When you are done, Close the Show Table dialog box.
    Show Table Dialog BoxShow Table Dialog Box
  • You should now see a relationship map that contains all of the tables that were selected.
    Relationship MapRelationship Map

Moving tables in the relationship map

To move a table that appears in the relationship map:

  • Place your mouse over the table you want to move.
  • Hold down the left mouse button, and drag the table to a new location.
  • Release the mouse button to drop the table in its new place.

previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.