Page 287 - Trackpad 402_Class-X_Final
P. 287

Step 4:  Repeat the above step to select :
                    •  Field: Adm No, Name, BookID, Title, Publisher
                    •  Table: Student for Adm No & Name, BOOKS ISSUED for
                    •  Sort: Title in ascending order

                    After doing all the above mentioned changes in the Query Design view will look like: BookID, Title, Publisher



























            Step 5:   Select File → Save As. The Save As dialog box appears with the default query name as Query1. You can also
                    change the query name.
            Step 6:  Click on OK button.










            Step 7:  Now click on File menu and select Close option.
                    Query1 will appear under the Queries pane in the Database window as shown below:
































                                                                                   Database  Management System  287
   282   283   284   285   286   287   288   289   290   291   292