Exam 4: Organizing and Manipulating the Data in Databases

An append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

An example of a data type for a database record field is "Memo."

Using Microsoft Access to create a select query with multiple criteria all of which you want satisfied at the same time), you should specify them on separate Criteria lines of the query.

Database management systems allow their users to create "input masks" which help to prevent input errors.

OLAP stands for:

A template that you can create in Microsoft Access and that prompts users for expected values is called a "mask."

An example of a data type for a data field in the record of an Access table is "Number."

An advantage of defining a default value for an Access data field is that it:

To create a relationship between two tables in Microsoft Access, you should use the Relationships window.

A useful guideline to follow when creating data fields containing text is to assign at least 50 characters to it.

Microsoft Access is an example of a database management system, not a database.

It is not possible to conduct multi-table queries using Microsoft Access because each table in the system is independent of the others.

Online analytical processing enables a computer system to display information that must be computed from the data stored in a database.

Which of these is true about finding data in multimedia databases?

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

The value that a database will use if the user does not provide an alternate value is called an):

A database schema is a plan of the entire database.

Database designers typically store employee Social Insurance numbers as "Long Integer" data types.

SQL is an example of a database query language.

Databases are the same thing as database management systems.