Exam 19: Implementing a Database With Microsoft Access

Which of the following is a one-step method for saving the changes you make to a table,query,form,or report in Microsoft Access?

An intersection relation is a relation you create to eliminate a one-to-many relationship.

If you needed a title to print on the top of each page of a multi-page report,where would you place this title in the report design?

What type of query seeks results based on some specification?

To change the structure of the database,you must be in the datasheet view.

What relationship exists when a primary key may appear many times as a foreign key,and a foreign key must appear once and only once as a primary key?

The Field Size in Microsoft Access defaults to _____ characters.

A(n)_____ is a relation created to eliminate a many-to-many relationship.

A(n)_____ tool helps you graphically design the answer to a question.

By turning on the enforcement of referential integrity option,your DBMS will make sure that when you enter a _____ key in a relation it matches one of the _____ keys in the other relation.

In Access,a report can be created using either Design View or the ____.

A foreign key is a primary key of one file that appears in another file.

Entering information into an Access table is referred to as _____ it.

_____ simplify the task of entering new information and can make field areas longer or shorter,change text colors,and add and remove fields and labels.

When you're creating relationships,what Access option allows you to protect your database from inconsistent data?

What is the fundamental difference between tables (or queries)and reports?

Which personal database management system software is the most popular?

An intersection relation is also known as a composite relation.

For text fields,which of the following is the default field size?

A primary key is a field (or group of fields in some cases)that uniquely describes each _____ in a table.