Exam 11: Behind the Scenes: Databases and Information Systems

A(n) ________ report provides a list of the transactions that occurred during a certain time period.

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

Data ________ means that the data contained in a database is accurate and reliable.

In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.

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

Data redundancy ensures that the data contained in the database is accurate and reliable.

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

A data dictionary is also referred to as a(n) ________.

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

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

In an Access database, changing the ________ enables you to display the field name in a more meaningful or readable manner.

A group of related records is called a table.

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

Which of the following is NOT a database component?

A(n) ________ is created from a large data business warehouse to analyze a single component of the business.

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

When using Access, the text of the Declaration of Independence would be stored in a short text field.

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.

________ Query Language is similar in many respects to Structured Query Language.