Term4_Exam_Grade 4

Label the parts of the data table using the words: data item, record, and field.

How many fields are in the data table?

List the names of the fields in the data table.

a. A data table is the basic unit of a ​ (a)   .

b. Data is organized in rows and columns in a data ​ (b)   .

c. A field holds a single piece of ​ (c)   in a record.

d. A ​ (d)   is a collection of fields about the same person or object in a database.

• database
• table
• data
• record

State whether the following statements are true or false:

Each column in a data table represents a unique field.

• true

• false

State whether the following statements are true or false:

Calculations cannot be performed on data that is of type Text.

• false

• true

Stat whether the following statements are true or false:

Some fields can hold data in different formats.

• true

• false

State whether the following statements are true or false:

A field with data type Text can only store letters.

• true

• false

Stat whether the following statements are true or false:

A field with a data type of Yes/No can store data with many possible values.

• true

• false

What is the data type of each field? Match to choose the correct data type. Look at your book on page numbers 96.

• Currency

• Student Name

• Date/Time

• Contact Number

• Text

• Pick-up Time

• Text

• Outstanding Library Fee

• Yes/No

• Member of School Clubs