Page 248 - IT_V1.0_Class10
P. 248
Creating a Query using Query Wizard
Perform the following steps to create a query using Query Wizard:
Step 1: Open the database for which you want to
create a query. In this case, we have opened the
school database.
Step 2: Click on the Queries object from the Database pane.
Step 3: Click on the Use Wizard to Create Query option 3
under the Tasks pane. The Query Wizard will appear
2
with the Field selection step.
Step 4: Select the table based on which you want to create a
query from the Tables drop-down list. In this case, we have selected Student table. All the fields of
the selected table appear in the Available Fields list box.
Step 5: Select the STUD_ID option from the Available fields list box
Step 6: Click on the > button to move the selected field to the Fields in the Query list box. Similarly,
move the STU_NAME, CLASS and ROLL_NO fields from the Available fields list box to Fields in
the Query list box.
Step 7: Click on the Next button.
4
5
6
7
The Sorting order step of the Query Wizard will appear. In this step, you can specify the sorting
order for records. In this case, we have retained the default settings.
Step 8: Click on the Next button. The Search condition step of the Query Wizard will appear, where you
can specify the condition according to which the query will return the result.
Step 9: Select the field on which you want to set the condition from the Fields drop-down list. In this case,
we have selected the CLASS field.
Step 10: Select the condition from the Condition drop-down list. In this case, we have selected the is equal
to condition.
Step 11: Specify the value for the condition in the Value text box. In this case, we have specified 10. You can
also add more than one condition according to your requirement in the given boxes.
Step 12: Click on the Next button.
246 Information Technology Play (Ver 1.0)-X

