Q. Explain the procedure of defining relationship in Ms Access?
Ans.
Database Relationship
A relationship is a logical connection between different tables. A relationship is established on the basis of interaction among these tables. The relationship is established connecting one or more fields of two tables. The fields used to connect two tables normally have same name, data type and size.
Defining Relationship
The procedure for creating relationship between tables is as follows:
- Open the database file.
- Click the Relationship icon on the toolbar OR Click Tools=>Relationships. The Relationship window will appear
- Click the name of the table to be added to the relationships.
- Click Add button.
- Click Close button after adding all required tables. The added tables and their fields will appear in Relationship window.
- Click and drag a primary key field from one table to the corresponding field in the other table.
- Release the mouse button. The Edit Relationships window will appear.
- Select Enforce Referential Integrity checkbox.
- Click Create button. The relationship will be created. A line between the related fields will appear in Relationship window.