Page 42 - Code Craft Computer-8

B. Gap-fill exercise.

1. _____________ view is used to enter data in a table.
2. In _____________ view of the table, you can enter the field names, their data types and
description.

3. A table consists of _____________ and _____________.
4. The _____________ data type is used to store lengthy text that is up to 65,536 characters.

5. The _____________ data type is used to store text or a combination of text and numbers.

C. True and False assessment.
1. A database can have only one table.

2. Number data type is used for numeric data that will be used in calculations.
3. Caption property is used to give an alternate name to a field.

4. Field Properties Pane is used to set properties for the fields in the table.

5. Primary key option is available on the Home tab.

D. Give appropriate responses to the questions.
1. What do you understand by the term 'table'? Name some important components of a
table.

2. What is a primary key? How do we set primary key in Access?
3. Explain the two parts of the Design View Window?

4. How will you sort the data within a table?
5. What do you mean by data types?

Analyt ical Skills

Pictorial-Based Learning

Identify the following pictures and write their names.

1. _________________________

2. _________________________

3. _________________________

4. _________________________

42