Session 1.1 Quick Check

Add & Delete

Which group on the Fields tab contains the options you use to add new fields to a table?

Field

A(n) _______ is a single characteristic of a person, place, object, event, or idea.

Access saves changes to the active database automatically, when a record is changed or added or when you close the database. You use the Save button in Access only to save changes to the design of an object, such as a table, or to the format of a datasheet-but not to save the database file.

Explain how the saving process in Access is different from saving in other office programs.

Navigation Pane

The _______ is the area of the Access window that lists all the objects in a database, and it is the main control center for opening and working with database objects.

Primary Key; Foreign Key

The _________, whose values uniquely identify each record in a table, is called a(n) _______ when it is placed in a second table to form a relationship between the two tables.

The record being edited; the next row available for a new record

What does a pencil symbol at the beginning of a record represent? What does a star symbol represent?

ID

What is the name of the field that Access creates, by default, as the primary key field for a new table in Datasheet View?

Common Field

You connect the records in two separate tables though a(n) __________ that appears in both tables.