Page 279 - IT 402 v2.0 class 10
P. 279
Creating a Query using Query Wizard
erform the following steps to create a uery using uery i ard:
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 under the Tasks pane. The Query Wizard will
appear with the Field selection step.
3
1
2
Step 4: Select the table on which you want to create a uery from the Tables drop-down list. In this case,
we have selected Student table. ll the fields of the selected table appear in the Available Fields
box.
Step 5: Select the field which you want to include in the uery and add it to the Fields in the Query box by
clicking on the > button. In this case we have added all the fields.
Database Management 277

