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

