Page 286 - IT 402 v2.0 class 10
P. 286

Step 6:   ouble-click on the  uery name to run the  uery. Notice that a new column titled Amount Payable
                is displayed showing the necessary calculations.  emember that calculation can be made only on
                those fields where data type used is Numeric.

        Grouping Data in Queries

        In business organisations and companies, the senior management needs reports in summary form. In such
        situations  a summary report can be prepared grouping records on the basis of field that contains repetitive
        values.
        For example, consider the stock table of a departmental  store which  sells  items  that  include  Kitchen
        Appliances, Furniture and Decoration. The senior management wants to know the quantity of stock under
        each category of products.














        Observe in the given table that some of the entries in the Product_Category field are repeating.  ase allows
        the user to categorise the data on this field.  his field on the basis of which data is being grouped is called
        group-field.
         ase creates  ueries for grouping data on the basis of:
           roup-field

          Grouping function
        Grouping function refers to the in-built function used to present grouped data. The grouped data can be
        presented in the form of S M           M  IM M  MINIM M   O N   etc. of the values stored in the table.

        To create a grouping query, follow these steps;

        Step 1:  Create a new query in the Design view.
        Step 2:  In the Field row in the Query Design pane  in the first column  select and use the group-field  which
                in this case is Product_Category.







                                                                      2



















         284       Touchpad Information Technology-X
   281   282   283   284   285   286   287   288   289   290   291