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

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

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

In the accompanying figure, the small box or bar to the left of each field is called the ____.

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, and then tap or click Rename Field on the shortcut menu.

In Access, table and field names can be up to ____ characters in length.

The DATABASE TOOLS tab provides commands to save a database with another name.

To import data to a table, tap or click the ____ tab on the ribbon.

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

The Navigation Pane contains a list of all the objects in the database.

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

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

When you create a database, you should follow some general guidelines for database design.What are these nine guidelines?

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____________________ on the shortcut menu.

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

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.

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.

Form view displays a single record at a time.

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