Page 105 - TP_iPlus_V2.1_Class7
P. 105
5 Drag and drop the Primary Key field of one
table to the common field in the another table. 6 Click on the Create button.
This will create a line or relationship between 'StudentsDetail' table and 'StudentsMarks' table
based on the Primary Key named ‘Roll No’.
Relationship
established.
Creating a Query
To create a query, follow the given steps:
1 Click on the
Create tab. 2 Click on the Query Design command on the Queries group.
3 Select the desired table and click on the Add button.
4 Double click to add the field's name to the query window. 5 Specify the criteria.
103
More on Access

