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
   100   101   102   103   104   105   106   107   108   109   110