Page 224 - Computer - 10(A&B)

The Query Design Window appears with Add Table or Query window with a list of tables.

Step 4: Select the table from which the information is to be extracted and click on Add button to show the table
in Query Design window.

The Query Design window is divided into two parts. The upper part displays the tables selected for
the query. The bottom part displays options to add fields and specify the criteria. It has the following
options:
• Field: to display the fields from the selected table.
• Table: to display the name of the table.
• Sort: to arrange the data in ascending or descending order.
• Visible: displays a check mark which means the field will be visible when the query is run.
• Criterion: to specify the condition on the basis of which the records will be filtered.
• Or: to specify multiple criteria.

Step 5: Choose the fields you want from the drop down list of the Field option in the bottom part of Query
Design window.

106