Exam 12: Tables,Keys,and Relationships

An input mask sets a specific ________ and provides the punctuation,so it does not have to be typed manually.

When you have a one-to-one relationship,you could combine the two tables into a single table.

The maximum length of a data field is indicated by its ________.

In a database,a(n)________ is a field that uniquely identifies a record.

When a relationship is defined to enforce referential integrity and Cascade ________ Related Fields,Access will automatically change the data through all related tables when a revision is made to the data in the table that contains the primary key.

Deleting individual fields from a table is ________ and cannot be undone.

Access can import smaller sections of a worksheet known as a ________.

Database design is considered to be a three-step process.

A quantity field would be best formatted as the ________ data type.

When importing data from an Excel worksheet into a new Access table,the headings are often imported as the field names.

A character,such as a colon or comma,that separates fields is a ________.

Being able to format a phone number in a field as (412)555-8676 without manually entering the symbols occurs when an ________ has been applied to the field.

The ________ in a table dictates what data can be stored in a field.

The ________ property helps Access understand how to display data.

Which of the following is NOT true about a table's Design view?

Unless a common field is being joined,such as a foreign key to the same foreign key in A different table,Access cannot form a ________ relationship with a single relationship.

The size of a field can be changed in a table's Design view.

A relationship between tables in which a record in one table has many matching records in the second table is a ________.

The ________ key in one table acts as a primary key of another table.