Page 250 - IT_V1.0_Class10
P. 250

17
                                                                        18














                                                                        19




              Editing a Query
              Perform the following steps to edit a query:

              Step 1:   Open the database containing the query that you want to edit.
              Step 2:   Click on the Queries object from the Database pane.

              Step 3:   Right-click on the query to be edited in the Queries pane.
              Step 4:  Select the Edit option from the context menu. The query opens in a Query Design window where
                       you can make the required changes.

              Step 5:  Modify the query according to your requirement. In our case, we have specified the 11 in place of
                       10 in the CLASS field for the Criterion option.
              Step 6:   Click on the Save button in the Query Design toolbar.




                                                                  6









                    2



                    4


                    3                                                                                           5


              Now, if you run the query, you will get the following output.










                248     Information Technology Play (Ver 1.0)-X
   245   246   247   248   249   250   251   252   253   254   255