Exam 12: Tables,Keys,and Relationships

By establishing a relationship between two tables that is based on a common field in the two tables,a ________ is being created.

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

A delimiter is a character that separates fields within a text or Word file.

A(n)________ table separates a many-to-many relationship into two one-to-many relationships.

If one customer can purchase many items,one-to-many is called the ________ of the relationship.

If you cause an error in Access,you can press Esc to get out of it.

To ensure that information is entered,sorted,and displayed consistently,an input mask can be defined in a field.

The best type of key to use for fields such as CustomerID and ProductID would be an arbitrary ________ key.

All information about a database's table joins are stored ________.

The AutoNumber data type is best used for the primary key.

Tables have ________ view(s).

Tables have two views: Datasheet view and Design view

A(n)________ is a link between tables.

The Description property in a table's Design view is required.

An appropriate example of the type of data that could be stored in an Attachment data type field is ________.

An entity is a characteristic of an attribute.

To copy and paste from Excel into Access,ensure that the columns are exactly the same in the two applications.

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