Exam 2: Databases and Database Objects: an Introduction

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

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

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

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

One way to undo changes to a field is to click the Undo button on the Quick Access Toolbar.

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

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

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

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

To rename a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.

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

In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____ for the table.

To save the changes to the layout of a table, click the Save button on the _____.

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

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

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

Redundancy is the storing of a piece of data in more than one place.

The ____________________ feature of Access corrects common mistakes when you complete a text entry in a cell.