Page 286 - Trackpad 402_Class-X_Final
P. 286

Step 2:   Select the tables you wish to use in the design view. In this case, we have added two tables named BOOKS
                ISSUED and STUDENT. Now the screen will have two tables with 1:1 relationship as shown below:



































                •  The query design view has two sections - upper action has tables to be used to design a query. The lower
                  section is the design query parameters where you specify:

                      w Fields: Displays the selected fields in the output of the given query.
                      w Alias: Give another name to the field in the output window.
                      w Table: Table from which the field is to be selected.
                      w Sort: If the field is to be arranged in ascending or descending order.
                      w Visible: If selected the field will be displayed in the output window.
                      w Criterion: The condition for the rows to be displayed.
        Step 3:  Click on drop-down arrow key in front of the field to select Adm No as shown below:

































          286   Trackpad Information Technology-X
   281   282   283   284   285   286   287   288   289   290   291