Page 44 - ModularV1.1 _c8_flipbook
P. 44

Recap


                          The  Totals command  allows you  to  perform  different  types  of  calculations  like sum,
                        average, maximum, minimum, standard deviation and covariance.
                          MS Access allows you to search a particular record in a table easily by using the Find
                        command.
                          Sorting is the process of arranging data alphabetically either in ascending or descending
                        order.
                         Filtering means to select specific data from the given set of data.

                          Importing  data  means to access the data  from other  applications like  MS Excel to
                        MS Access.
                          Exporting data means to save an MS Access table data into different formats like PDF or
                        spreadsheet.


                                                         Exercise



                  A.  Tick ( ) the correct option.
                           ü
                     1.  Which of the following command is used to perform calculation in MS Access?
                       a. Totals                            b. Filter                     c. Sort

                     2.  Which of the following command is used to find a record in a table?

                       a. Replace                           b. Sort                       c. Find
                     3.  Which of the following is not a sorting option?

                       a. Sort A to Z                       b. Sort A to B                c. Sort Z to A

                     4.  Which of the following tab is used to import data from other applications to MS Access?
                       a. External Data                     b. Database Tools             c. Fields

                     5.   Which of the following group of the External Data tab is used to export data from
                        MS Access table?

                       a. Sort & Filter                     b. Import & Link              c. Export

                  B.  Fill in the blanks using the words given below.


                                                         excel, find, PDF or XPS, sorting


                     1.  ................................ is the process of arranging data alphabetically either in ascending or descending
                        order.

                     2.  The ................................ command is used to import data from an MS Excel file.
                     3.  The Find command is present under the ................................ group of the Home tab.

                     4.  The ................................ command is used to export the data in PDF form.


                  42      Modular (Ver. 1.1)-VIII
   39   40   41   42   43   44   45   46   47   48   49