Page 277 - IT 402 v2.0 class 10
P. 277

   se  i ard to create  uery...
               reate  uery in S   view...

             xample:  onsider a database in which a data of the  ustomers is stored in a table namely    S OM  S   and
            in this table  many records are having there with the names of the city as  N.    I  and we have to display
            only those records in which name of the city is stored as  N.    I .

            Now let us use  uery for the same.

            Create Query in Design View.... [Single Table]

             et us now learn how to create  uery in  esign view in  Single  able.
               lick on the   ueries  icon from the  atabase  indow.

               lick on the option   reate  uery in  esign  iew ....  option to create a  uery in  esign view.
             he  uery  esign window opens:









                              Queries Icon











            Step 1:  Select the table from the   dd  able or  uery  window and click on the   dd  button.

             Follow the steps if you want to include more than one table in the  uery.
            The selected table appears on the window below the standard toolbar.



























            Step 2:   lick on  Field  dropdown box and select the fields that will be displayed in the  uery.  he user can
                    apply the criteria for sorting with conditions that will be applied in the  uery by clicking on  Sort  and
                    selecting the condition.



                                                                                  Database Management          275
   272   273   274   275   276   277   278   279   280   281   282