Exam 19: Implementing a Database With Microsoft Access

Microsoft Access's data _____ subsystem is used to enter and change information and build queries.

The competitive advantage for many people seeking employment is knowledge in which of the following software packages?

Access defaults to identifying the first field in a relation as the _____ key.

When entering information into an Access table where referential integrity has been violated,Access displays a(n)_____ alert and does not allow you to continue.

In a database management system,the word relation is also called a table or file.

An intersection relation is sometimes called a(n)____.

Which Access Wizard would you use if you want to generate a simple report?

When creating the structure of a relation,the result of changing the _____ to "No",means that something must be entered into the field name when a new record is added.

Where does the information about field format and file sizes get stored in Microsoft Access?

In a one-to-many relationship (1:M),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.

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

The data mart contains the logical structure for the information in a database.

Where do you turn on the "Enforce Referential Integrity" option in Access?

The data dictionary includes a description of each relation and each piece of information in each relation.

After entering information into each field of an Access table,you use the _____ key to get into the next field or row.

When you drag and drop a foreign key onto a primary key,Microsoft Access assumes that the relationship is a many-to-one (M:1).

As a general rule,when establishing relationships between a primary and foreign key,you should turn on _____ to protect your database from inconsistent data.

When defining a database structure,what does Access default to when identifying the first field?

Microsoft Access's application generation subsystem is used to create reports and input forms.

Integrity constraints are the rules that help ensure the quality of information.