Exam 3: Databases and Database Objects: an Introduction

The Currency data type is used for fields that contain only monetary data.

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

In the accompanying figure, ____________________ for the open objects appear at the top of the work area.

A hard copy or ____________________ is information that exists on a physical medium such as paper.

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

Modified Multiple Choice File names cannot contain a(n) ____.

The Short Text data type replaces the ____________________ data type in previous editions of Access.

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

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.

A(n) ____________________ contains a specific piece of information within a record.

To preview and then print the contents of a table, use Table Preview.

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

Discuss the difference between the way Access saves a record and the way Excel saves a row in a worksheet.

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu.

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

In the accompanying figure, the words Datasheet View at the lower left of the screen appear on the ____________________.

Changing the column width in a datasheet changes the structure of a table.

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

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