Page 105 - iPrime_V2.2_class7
P. 105
Creating a Query
To create a query, follow these steps:
Step 1 Click on the Query Design command from the Queries group under the Create tab.
Creating a query
Step 2 The Show Table dialog box will open. Select the desired table and click on the Add
button.
Step 3 Add the field's name to the query window and specify the criteria.
Defining query criteria
The parameters of the design grid in the bottom part of the Query window are:
Field: It is the first row of the design grid that displays the selected field names from the table.
Table: It displays the name of the existing tables in the relationship window.
Show: This means that the field with the checkmark will be displayed in the result and the
fields with an uncheck mark will not be displayed when the query runs.
Sort: It displays the data in either descending or ascending order during the run time.
Criteria: This displays the condition on the basis of which the records will be filtered and
displayed in the query output.
Or: It is used to set multiple conditions in a query.
After creating the query, we need to run the query by clicking on the Run button . The related
records of the query will be displayed in the Datasheet view.
More on Access 103

