Access Terms

Access checks field validation rules when a user navigates out of the field.

• True

• False

An input mask forces a user to enter data using a specific format.

• True

• False

Before adding a new field between existing fields in a table, you must insert a new row.

• True

• False

How does Access store a Yes response for the Yes/No data type?

• -2

• -1

• 0

• 1

How is data in a relational database system organized?

• collection of related fields

• collection of related records

• collection of related tables

• collection of related cells

If a field must have a value you should set the Required property to Yes.

• True

• False

New tables created in Design view do not contain any fields.

• True

• False

The Format property controls the way a field displays in a table; it doesn't change what is actually stored.

• True

• False

What is a primary key called that is made up of more than one field?

• primary key

• foreign key

• concatenated key

• combined key

What must be added into a table before relationships between two tables can be established?

• primary key

• foreign key

• junction key

• concatenated key