Page 104 - iPlus_Ver_2.0_class_7
P. 104
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 2 Click on the Query Design command.
Create tab.
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.
102
iPlus (Ver. 2.0)-VII

