Exam 10: Creating a Database

Each row in a database table represents a field.

When entering data, you can use the _____ key(s) to move from one field to the next without having to move your hand to the mouse.

An empty table does not contain any fields.

Use the Short Text data type for fields that contain variable length data.

Each category of data is stored in a database _________.

Which of the following fields is designed to be used as the primary key in an empty table?

You should use the ________ data type for fields that contain truth values.

Access provides several tools you can use to manipulate the database, and they are contained in the Navigation Pane on the right side of the database window.

When a table is open, the ribbon includes the ___________ contextual tab for working with individual fields and records.

You can modify data within a field using Backspace, Delete, and typing keys. To complete the modification you should press the _____ key.

The primary key is an important field in an Access table. Please describe a primary key. Does Access create the primary key or can you create it yourself?

A(n) _______ contains criteria that specify what you would like to find.

Case Based Critical Thinking Questions Case 10-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Referring to the figure above, James asks which of the columns is a primary key. Maxwell points to _____.

Data import options are listed on Access's IMPORT/EXPORT DATA tab.

All of the following are elements that make up the database, except _______.

All of the following are controls for operations that can be performed on a table, except __________.

After opening a New Query window, which of the following would you usually select?

A(n) record contains a single unit of information.

Creating a new database simply makes a(n) ________ that becomes the container for the tables, data, queries, and reports.

You should use the ________ data type for fields that contain variable length data.