Page 115 - Viva ICSE Computer Studies 7 : E-book

Quick Recall

• By default, a table is created in the Datasheet view.
• The Design view allows you to enter names of the fi elds in the table and specify their data types.

• A primary key is a fi eld that contains unique values such as Roll Number and ID.
• Table can be edited in both the views: Datasheet view and Design view.
• Freezing in Access means to keep the selected fi eld/column to the left side of the table and also
visible at all times, irrespective of the direction of your scroll.
• Access provides a Navigation Toolbar to move through the records.
• Sorting means to arrange the data in ascending or descending order.
• A query helps you to extract information from one or more tables in a database that meets the
conditions specifi ed by you.
• Relationship is built on a fi eld of one table with the same fi eld of another table.
• A query is based on tables, other queries or a combination of both.

A. Fill in the blanks.

1. By default, a table is created in _______________ view.

2. The workspace of a Database Interface window shows a table with default name ‘_________’
in the Datasheet view.
3. Access provides a _______________ Toolbar to move through the records.

4. Sorting means to arrange the data in _______________ or _______________ order.

5. _______________ displays the selected fi eld names from the table.

B. State whether the following statements are true or false.

1. Data can be entered directly into the table in rows and columns in the
Design view. __________

2. Datasheet view is used by programmers and professionals. __________

3. A data type indicates the kind of data to be stored. __________
4. A table can be edited only in the Design view. __________

5. Freezing in Access means to keep the selected fi eld/column to the left side
of the table and also visible at all times, irrespective of the direction of your
scroll. __________

103