Create Table relationships

Task: Create  Table relationships		No	E2
No	Steps	Yes	No
01	Open the software Package
02	Open the exiting database
03	Select relationships command(Database Tool)
04	Add for all the require tables
05	Identify primary key of the table
06	Identify foreign key of the table
07	Drag and drop primary key on to foreign key
08	Select appropriate join type
09	Click referential integrates check box depending on requirement
10	Create relationships

Establishing Relationships

To establish a relationship between tables:

1.       l 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.

2.       Relationships Command

3.       When the Show Table dialog box appears:

4.       Select each table name and click Add for the tables you want to relate.

5.       By now, you have set up the tables you need for your database, and created fields for those different tables. Relationships provide Access 2007 with the means to bring that information together for you when you need it. This lesson explains how to establish relationships between the tables in an Access 2007 database. You will learn how to read and manipulate the relationship map. You will also learn about Primary and Foreign Keys, relationship types, and about 

referential integrity.

6.       When you are done,

7.       Close the Show Table dialog box.

You should now see a relationship map that contains all the tables that were selected.

Moving Tables in the Relationship Map

To move a table that appears in the relationship map:

1.       Place your mouse over the table you want to move.

2.       Hold down the left mouse button, and drag the table to a new location.

3.       Release the mouse button to drop the table in its new place.

4.       Using the Edit Relationships command located on the Design tab of the Ribbon

5.       Using the Drag and Drop method

6.       Both methods give you the same end result, but the Drag and Drop method is much easier and saves you

7.       Several steps.

8.       Select a field name from one table by holding down the left mouse button.

9.       Relationship Map

10.   Drag the field name from the one table to the other table in the desired relationship.

11.   Drop the first field name onto the field name that you want to relate by releasing the left mouse button.