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

