When you create a blank database, Access creates the first table for you and gives it the name Database1.

In a table, the primary key is the field that contains a unique field value for each record in the table.

A field’s access type determines the kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text.

Left-aligned field values are usually Number fields.

In Design view, you can add, delete, and make changes to the way that fields store data.

The first step in creating a database is to create the file that will store the database ____.

When you use a ____ to create a database, it creates the database and one or more table, query, form, and report objects that you use to enter and view data.

To save a table, click the Save button on the ____.

When you create a blank database, the table that Access creates for you contains one
field named ____.

The ____ is the field that contains a unique field value for each record in the table.

A field’s ____ determines the kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text.

The ____ data type stores graphics, sound, and movie files as attachments.

You need to save a table only when you make changes to its layout, such as ____.

In ____, you can add, delete, and make changes to the way that fields store data.

Just like when you select a record selector in a datasheet, the record selector for a selected field
in the design grid changes color to ____ when the field is selected.

Any changes that you make in Design view are automatically updated in ____ when you save the table.

The ____ sets the number of characters you can store in a Text, Number, or
AutoNumber field.

FIGURE 2-1


Access Case 2-1
Kristin has put together a list of job candidates for various positions within her company.  In Figure 2-1, she needs to confirm the data type for one column and also set the primary key.

The ____ field would make the best primary key because there would never be two people with the same data in that field.

Acccess Case 2-2
Sam is putting together a database where there are some fields that must be filled in and also some fields where he wants to put in a default value.  He is researching which Access properties will help him with his task.

To make sure that a specific field is filled in and has data in it, Sam will use the ____ property.

To set a default value that will automatically appear for some of the fields, Sam will use the ____ property.