Page 99 - iPro_trackGPT_V5_Class7
P. 99
5 Click on the Create button.
4 Drag and drop
the Primary Key field
of one table to the
common field in the
another table.
This will create a line or relationship between 'Student's Detail' table and 'Fee' 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.
3 Select the desired
table and click on the
Add Selected Tables
button.
5 Specify the criteria.
4 Double click to add the field's name to the query window.
More on Access 97

