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
   243   244   245   246   247   248   249   250   251   252   253