Page 38 - ModularV1.1 _c8_flipbook
P. 38

05                   ADVANCED FEATURES


                                                                                       OF MS ACCESS














                              Your Aim

                             to learn about:
                               l  Performing Calculation                           l  Searching Records
                                l  Sorting Records                                   l  Applying Filters in a Table
                                  l  Importing Data from Other Applications        l  Exporting Data from MS Access

                  In the previous chapters, you have learnt about the basic concepts of database and MS Access
                  2010. You have also learnt how to work with a table. This chapter introduces some advanced
                  features of MS Access 2010.

                      PERFORMING CALCULATION
                  You can perform calculations in MS Access by using the Totals command. The Totals command

                  allows you to perform different types of calculations like sum, average, maximum, minimum,
                  standard  deviation and covariance.  Follow these
                  steps to perform calculation in the table:
                  Step 1  Create a new table or open an existing table
                          in which you want to perform calculation.
                          In this case, we have created  a new  table
                          named Items.

                  Step 2  Click on the  Totals command under the
                          Records group of the Home tab. A new row
                          with the text Total will be added after the last
                          record in the table.                                        Performing calculation
                  Step 3  Click on the cell where you want to perform the calculation.
                  Step 4  Click on the down-arrow. A list of functions appears.
                  Step 5  Select the desired function. In this case, we have selected the Sum function. When you

                          select the Sum function, the sum of values appears in the cell.










                                                      Result after using Sum function

                  36      Modular (Ver. 1.1)-VIII
   33   34   35   36   37   38   39   40   41   42   43