ANSWER IN SHORT :-
How do we create relationship among tables?
Answers
It cant be in short .
.
Create a table relationship by using the Relationships window
On the Database Tools tab, in the Relationships group, click Relationships.
On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013).
Select one or more tables or queries and then click Add.
Answer:
Explanation:
A relationship in Access helps you combine data from two different tables. Each relationship consists of fields in two tables with corresponding data. For example, you might have a ProductID field in a Products table and in an OrderDetails table. Each record in the OrderDetails table has a ProductID that corresponds to a record in the Products table with the same ProductID.
When you use related tables in a query, the relationship lets Access determine which records from each table to combine in the result set. A relationship can also help prevent missing data, by keeping deleted data from getting out of synch, and this is called referential integrity.
Before you work with relationships, make sure you understand the background concepts. For more information, see Guide to table relationships and Get started with table relationships.
1.On the Database Tools tab, in the Relationships group, click Relationships.
2.On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013).
3.Select one or more tables or queries and then click Add. After you have finished adding tables and queries to the Relationships document tab, click Close.
4.Drag a field (typically the primary key) from one table to the common field (the foreign key) in the other table. To drag multiple fields, press the CTRL key, click each field, and then drag them.
5.verify that the field names shown are the common fields for the relationship. If a field name is incorrect, click on the field name and select the appropriate field from the list.
6.Click Create.
Access draws a relationship line between the two tables. If you selected the Enforce Referential Integrity check box, the line appears thicker at each end. In addition, again only if you selected the Enforce Referential Integrity check box, the number 1 appears over the thick portion on one side of the relationship line, and the infinity symbol (∞) appears over the thick portion on the on the other side of the line, as shown in the following figure.