Exam 2: Access Lesson 2: Creating a Database

A field's ____________________ determines the kind of data that you can enter in the field, such as numbers or text.

After specifying the file name and the location in which to store the database, click the ____ button to create the new database and open it in Access.

When you create a blank database, Access creates the first table in the database for you and names it ____.

All of these values are also good candidates to use as a table's primary key field EXCEPT ____.

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

The ____________________ database template creates a database with an empty table in it.

FIGURE AC 2-1 Figure AC 2-1 above shows Field properties for a(n) ____ field.

An AutoNumber field automatically adds a unique number to the primary key field for each record in the table.

You can click the Data Type arrow in the ____________________ group to display a list of data types for fields.

Because the primary key field in a table must contain a value, its Required property is set to Yes automatically. You must enter a value in a primary key field or Access ____.

Case AC 2-2 Jennifer is creating a new inventory management table for the pet store where she works. She is spending the time upfront to make sure the data types are all assigned correctly. Jennifer's boss asks her if they can include detailed descriptions of each item in the database. The descriptions would be approximately 5000 characters. For this field she assigns the ____ data type.

The ____ Value property enters the same field value in a field every time a new record is added to the table.

If you have a table with an ID field with the AutoNumber data type, when you enter a new record in the table, you do not need to type a value in this field.

Using the ____ data type, open the Expression Builder dialog box, which lets you specify fields and operators to use in calculations.

The ____ property specifies whether you must enter a field value in a record.

A combination of numbers and text is also called alphanumeric data.

When viewing a table in Design view, the bottom half of the Table window is called the Field ____ pane.

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

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

When you create a blank database, the table that Access creates for you contains one field named ID. Access sets the ID field as the table's ____________________.