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

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.

Landscape orientation means the printout is across the length (height) of the page.

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.

The ____________________ data type in Access is referred to as Money in SQL Server.

As shown in the accompanying figure, you can move to the first record in a table by clicking the Start record Navigation button.

To add a record to a table, tap or click the ____ record button.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

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

Which field in the Project table should be the primary key and why?

What data type should Joe use for the Social Security Number field? Why?

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

In the accompanying figure, the entire area that displays on the screen is called the ____________________ work area.

A unique identifier also is called a(n) ____________________.

To save the changes to the layout of a table, tap or click the Save button on the ____.

When Access first creates a database, it automatically creates a table.

____________________ view has more functionality for creating a table than Datasheet view.

Access is a ____.