Exam 12: Tables,Keys,and Relationships

When manually entering data into an Access database,there is one method which is to enter it directly into the table.

When more than one field is used to create a key,it is referred to as a(n)________ key.

A(n)________ is an association between tables.

In text files,tables are implied by the separation of columns as denoted by a(n)________.

If a field exists that is currently part of your data,such as a Universal Product Code,it can be used as a(n)________ primary key.

In a database,________ occurs when data is repeated multiple times.

If one student in tblStudents can register for many classes in tblClasses,the relationship would be noted as a ________ relationship.

Database design can be looked at as a ________ process.

When a database is normalized,cardinality is minimized.

The ________ data type stores a maximum of 255 characters in the field.

When two fields are needed to uniquely identify a record,a ________ key is used.

When two tables have a one-to-many relationship,one-to-many is called the ________ of the relationship.

The ________ Number Field Size property is used for very large numbers with a maximum of 15 significant digits.

The Undo button will permit a user to undo up to 100 changes.

The value in a table that is the primary key of another table is a(n)________ key.

The Date/Time data type requires you to choose either date or time.

In Excel,a defined group is a group of cells that have been renamed.

A field that uniquely identifies a record is called a primary ________.