Page 330 - TP_IT_V1.0_C10_flipbpookl
P. 330

Step 3:   Add the tables you wish to use in the query. In this case, we have added two tables named STUDENT and
                      MARKS.
              Step 4:  Click the Close button in the Add Table or Query dialog box.
































              Step 5:  Create one to one relationship using the Adm No. field.
































                      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 grid with parameters where you specify:
                      •  Fields: Displays the selected fields in the output of the given query.
                      •  Alias: Give another name to the field in the output window.
                      •  Table: Table from which the field is to be selected.
                      •  Sort: If the field is to be arranged in ascending or descending order.
                      •  Visible: If selected the field will be displayed in the output window.
                      •  Criterion: The condition for the rows to be displayed.


                328   Trackpad Information Technology (Ver. 1.0)-X
   325   326   327   328   329   330   331   332   333   334   335