Exam 11: Behind the Scenes: Databases and Information Systems

In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) ________ field.

A database schema (dictionary) defines the name, data type, and length of each field in the database.

A table in Microsoft Word or a spreadsheet in Microsoft Excel, can be used as a flat database.

A small subset of data from a data warehouse is known as a(n) ________.

In a Access database, field size, caption, and Required and examples of a field's ________.

A(n) ________ is software that is used to gather and analyze data.

Normalization means that there are no data entry errors in a database.

A summary report generated by an MIS provides a list of the transactions that occurred during a specified time period.

To temporarily display records in an Access database from a single table that match certain criteria, you would use a(n) ________.

A(n) ________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

A database that allows data to be maintained in a single location provides data ________.

You can set a ________, which is automatically displayed in a field unless the user enters something different.