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

