Available Answers

1. 1.

   Fill in the blanks.

   1. __________ refers to the arrangement of data in an ascending or descending order.
   2. You can remove the filter by clicking on the _________ button
   3. _____________ makes a field visible at all times irrespective of the directions one scrolls.
   4. A __________ is a data sheet object that helps to retrieve and view information from one or more database tables.
   5. We can set multiple criteria in a query using _________ property.
2. 2.

   State True or False.

   1. Search box is located at the top of the Access screen
   2. To do calculations in a table, a table must be opened in the Design View. 
   3. Query window is divided into three panes. 
   4. Once a relationship is established between tables, it cannot be deleted. 
   5. Ms Access provides three types of query. 
3. 3.

   Swati created a database of her classmates and entered 30 records in it. The teacher has asked her to show the data of those students who have scored less than 50 % marks. Suggest her the method to apply this criterion.

4. 4.

   What do you understand by Sorting? How can you sort data in Access?

5. 5.

   What is the utility of Filter in Data sheet?

6. 6.

   What is a query? Explain the parts of a query window.