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
   274   275   276   277   278   279   280   281   282   283   284