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

Step 4:   The query opens in a new window where you can make the required changes. In this case, we have
                     modified the existing condition > ‘400’ to < ‘400’.

            Step 5:   Click on the Save button in the Standard toolbar.



                           5









                                                                                                    4










            Step 6:   Now if you run the  uery  you will get the different output.

















            Setting Multiple Fields Criteria
             erform the following steps to use multiple field criteria:

            Step 1:   reate a  uery in design view based on the following table:






















            Step 2:  Set the criteria in different fields. In this case  we have set the criteria in two fields.








                                                                                  Database Management          281
   278   279   280   281   282   283   284   285   286   287   288