Page 253 - IT_V1.0_Class10
P. 253

LibreOffice Base allows the user to categorise the data on this field. This field on the basis of which data is being
                 grouped is called group-field.

                 Grouping function refers to the inbuilt function used to present grouped data. The result of the grouped data
                 can be presented in the form of SUM, AVERAGE, MAXIMUM, MINIMUM, COUNT, etc.
                 To create a grouping query, follow these steps;

                 Step 1:  Create a new query in the Design view.
                 Step 2:  Select the field in the Field row based on which you want to form a group the group-field. In our
                          case, we have selected the Product_Category.

                 Step 3:   Select the Group option from the drop-down list beside the Function row or the Product_Category
                          field.

                 Step 4:   Select the field in the Field row in the new column whose value is grouped. In our case, we have
                          selected the Quantity.
                 Step 5:  Select the Sum option from the drop-down list beside the Function row for the Quantity field.






                                                                                                                  4





                                                   2
                                                         3                                                        5



                 Step 6:  Save the query with the name Query_Stock.
                 Step 7:  Double-click on the query in the Queries pane to run the query.

                          Notice that the sum of number of items in each category is shown upon execution of the query.


















                    Recap Zone


                      In a database, a query is a tool through which data is accessed or manipulated in a table.
                      Wildcard characters are used to retrieve a particular record from a table that contains a specified character.
                      Grouping function refers to the inbuilt function used to present grouped data





                                                                                                  Queries in Base   251
   248   249   250   251   252   253   254   255   256   257   258