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

____________________ refers to the process of determining the tables and fields that make up the database.

In Access, field names cannot contain digits.

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.

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

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

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.

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

You can place an insertion point by tapping or clicking in the field or by pressing ____.

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

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

File names cannot contain a(n) ____.

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data.

The Access window consists of a variety of components. These include the ____.

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

To define an additional field in Datasheet view, tap or click the ____ column heading.