Page 45 - ModularV1.1 _c8_flipbook
P. 45

C.  Write ‘T’ for true and ‘F’ for false.

                    1.  Custom filter allows you to filter data according to a particular criteria.     ...........................

                    2.  We cannot remove filter from a table.                                           ...........................
                    3.  Filtering means to select specific data from a given set of data.               ...........................

                    4.  We cannot search a record in an MS Access table.                                ...........................
                 D.  Short answer type questions.

                    1.  What is sorting?

                       ......................................................................................................................................................................................

                    2.  What do you mean by filtering?
                       ......................................................................................................................................................................................

                    3.  What is the meaning of exporting data?
                       ......................................................................................................................................................................................


                 E.  Long answer type questions.
                    1.  What is the difference between sorting data and filtering data?

                    2.  What is the difference between importing data and exporting data?
                                                   In the lab                                         Subject Enrichment


                       Create the following table in MS Access and enter 10 records:








                      After creating the table, perform the following operations:
                      •    Sort the records in ascending order according to the First Name field.
                      •     Apply filter on the Address field and display the records in which the address starts with the
                         letter M.
                      •    Export the data in spreadsheet format.
                       Create an excel worksheet and create the following columns:

                    Product_Code      Product_Name       Quantity    Customer_Name        Address    Pin Code

                      After creating the columns, perform the following operations:
                      •    Enter 20 records in the worksheet.
                      •    Save the file with the name Data to Import.
                      •    Open MS Access database and import the data from the Data to Import file.







                 1.   Do a walk-through of all the topics covered in this chapter.
                 2.   Explain different methods of Sorting and Filtering to the students.

                                                                                  Advanced Features of MS Access   43
   40   41   42   43   44   45   46   47   48   49   50