Exam 17: Creating a Database

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

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

By default, the data type for the primary key is _____.

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

To delete an entire record, _____ the row header containing the record, click Delete Record, then click the Yes button.

When a database is open, it is displayed in the Access _____ window.

Referring to the accompanying figure, which callout points to the tab that should be clicked first to build a query?

To open a table that was created peviously, you have to start Access, open the database, and then _____ the table name in the Navigation Pane.

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.

Which of the following contains information about a single entity in the database?

Each row in a database table represents a field.

Case Based Critical Thinking Questions Case 17-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. Kyra asks how to select all movies that received an award between 1940 and 1955. Maxwell tells her that the query criteria for the Award Year field should be: _____.

When you create a table you must specify a data type for each field. Please describe each of these data types: Date & Time, Number, AutoNumber, Yes/No.

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

Use the Short Text data type for fields that contain variable length data, such as comments, notes, and reviews.

Each category of data is stored in a database _____.

Fields names cannot contain spaces.

Case Based Critical Thinking Questions Case 17-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 accompanying figure, James asks which of the columns is a primary key. Maxwell points to _____.

Access saves each record as you enter it.

To define a field for a table, you begin by selecting a(n) ____________________.