Exam 6: Microsoft Access 2010,workshop 2: Gathering Data Into a Database

The ________ data type is a check box where an empty box represents no and a checked box represents yes.

Primary and foreign keys form a common field between tables that makes it possible to form a(n)________ between the two tables.

When working with tables,if you ________ a record or records,you CANNOT Undo the change.

The foreign key uniquely identifies each of the records in a table.

A relationship represents an entity in a database,while a field represents the data that connects the two tables.

Before you can create a relationship between two tables,they have to have a(n)________ in common.

When you delete individual fields from a table,these are permanent deletions that cannot be undone.

When you delete an individual field from a table,the deletion is ________.

When table data has a unique identifier that is already a part of the data,it is called a natural primary key.

To stop editing a record and revert it back to what it was before editing,you press ________.

Formats change the way data is stored in a database.

If you need to form a many-to-many relationship between two tables,you will need to create two one-to-many relationships called ________ to represent the many-to-many relationship.

Using an ________,Access gives you a way to consistently enter data.

If you need to use more than 255 characters in a text field,you should use the ________ data type.

The characteristic that determines the kind of data that can be entered into a field is called a(n)________.

A(n)________ is a set of cells that can be referred to by a name rather than by the cell references.

Access stores dates as a(n)________.

An association between tables based on common fields is called a(n)________.

When two fields are needed to uniquely identify a record,use a composite key.

A ________ is the primary key of one table stored in a second table to allow a relation to be created.