Page 289 - Trackpad 402_Class-X_Final
P. 289

Field in the Query: Click on > to shift one field at a time. You can also select >> to shift all fields together in one go.




























            Step 3:  Click on Next> to move to the next step of the wizard.
            Step 4:  In this step, select the sorting order to arrange the records in the ascending order of the field specified:
                    •  Sort By: BOOK ISSUED .BookID    Order By : Ascending

                       The dialog box with the given changes will look like:





























            Step 5:  Click on Next> to move to the next step of the wizard.
            Step 6:  Select the search criteria for the query:
                   •  Select the search condition or Match any of the following
                   •  Field - BOOK ISSUED.Publisher
                   •  Condition - is equal to
                   •  Value – Orange










                                                                                   Database  Management System  289
   284   285   286   287   288   289   290   291   292   293   294