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

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

To open the Navigation Pane, click the ____ Button.

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

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

In the accompanying figure, the Business Analyst Table displays in ____.

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

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

____________________ refers to the arrangement of data into tables and fields.

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 field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

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.

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

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 buttons at the bottom-right edge of the screen are ____________________ buttons, which you use to change the view that is currently displayed.

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

In the accompanying figure, the database name, Camashaly Design appears on the ____________________.

Form view displays a single record at a time.

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