What is Relationship ? Explain the steps to create
relationship in MS-Access.
Answers
the way in which two or more people or things are connected or the state of being connected is called relationship.
=steps to create relationship in ms access are
create a table relationship by using the relationships window
1.on the database,tools tab,in the relationships group,click relationships.
2.on the design tab,in the relationships group,click (or show table in access 2013).
3.select one or more tables or queries and then click add.
Explanation:
In the Relationships window, add the tables that you want to relate, and then drag the field to relate them from one table to the other table.
While viewing a table in Design view, and ensuring that the DESIGN tab is selected, click Relationships from the Ribbon
A Show Table dialog will appear with a list of tables and queries. Select the tables (and/or queries) that you wish to create a relationship between, and close the dialog
The Relationships tab will appear with the selected tables. Click and drag a field on top of a field in another table to initiate a relationship.
The Edit Relationships dialog will pop up containing both fields. Make any adjustments and click OK
This will create the relationship. You will see the tables in the Relationship tab with lines depicting the relationship between the tables.
While viewing a table in Design view, and ensuring that the DESIGN tab is selected, click Relationships from the Ribbon.
A Show Table dialog will appear with a list of tables and queries. Select the tables (and/or queries) that you wish to create a relationship between, and close the dialog.
The Relationships tab will appear with the selected tables. Click and drag a field on top of a field in another table to initiate a relationship
The Edit Relationships dialog will pop up containing both fields. Make any adjustments and click OK.