Exam 1: Access 1 Databases and Database Objects: an Introduction

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

In Access, the columns in a table are called records.

A field whose data type is ____ can contain any characters.

Layout view shows a report on the screen and allows the user to make changes to the report.

A unique identifier is also called a primary key.

The rows in the tables are called ____________________.

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

A(n) ____ contains information about a given person, product, or event.

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

Critical Thinking Questions Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the Completion Date field?

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

The determination of database requirements is part of a process known as ____________________.

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

To open the Navigation Pane, tap or click the ____ Button.