Exam 11: Using Databases

A group of related fields is called a ________.

The information about a single student would be stored in a ________.

A(n) ________ is a collection of related data that can be stored, organized, and queried.

To combine data from more than one table, you need to create a(n) ________ between the tables.

________ fields hold things such as pictures and video clips.

In a table, if you need to store the extended price (number of units sold times the price per unit) of an order, you would store the data in a ________ field.

A group of related records is called a(n) ________.

To establish a relationship between two tables, the primary key in one table is associated with the ________ in the other table.

In a database, a text field capable of holding complete paragraphs has a ________ data type.

What is the Access object that organizes data into fields and records?

To ensure that there are no duplicate records in a database table, you need to establish a ________.

In terms of databases, a table is also referred to as a(n) ________.

The results of multiplying the Hours field times the Rate field would be stored in a(n) ________ field.

A(n) ________ database stores data in more than two dimensions.

A category of information about students, such as their phone numbers, would be stored in a(n) ________.

Match each of the following terms to its definition: I. field II. relationship III. record IV. table V. primary key A. a group of related fields B. a category of information in a database C. a link between tables that defines how the data is connected D. a field that has a value unique to each record E. a group of related records

Which of the following is NOT a database component?

Most small businesses use ________ databases as they are reliable and less costly.