Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 116 - CoreGPT(Podar)_Flipbook_C8
P. 116

    Parameter Query: It is a type of select query which prompts you for the input before it runs.
                         The query then uses the input as the criteria that controls the result.

                           Action Query: It creates a new table or alters your data by adding, deleting, updating and
                         appending data from it.

                           Crosstab Query: It is a query that organise data into a table where rows and columns show
                         different categories.

                          Aggregate Query: This type of query is used to perform calculations on a group of data. It
                         allows you to summarise or analyse data by applying functions such as, SUM, AVG, COUNT,
                         MIN and MAX to selected fields.
                      Creating a Query

                      To create a query, follow these steps:

                      Step 1  Click on the Queries button in Database pane.
                      Step 2  Click on the Create Query in Design View option in Tasks pane. The Add Table or
                               Query dialog box will open.
                      Step 3  Select the tables to be added and click on the Add button.

                                         Creating a query                            Add Table or Query dialog box

                      Step 4  Add the field's name to the query window and specify the criteria.

                                                              Defining query criteria

                    114     Premium Edition-VIII

| 111 112 113 114 115 116 117 118 119 120 121 |