Exam 2: Getting Started With Access 2.0

The formula =A4+A8*($B$12) is an example of a(n) ____________________ formula.

The lower pane of a split form displays a datasheet view.

____ operators perform mathematical calculations such as adding and subtracting.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

On a form, ____________________ View is used to modify controls and does not display data.

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

A(n) ____ is an entry in a cell that contain text such as "2011 Sales" or "Travel Expenses."

Filter By ____________________ filters records based on more than one selection criteria by using a special window.

Koch labels are the most common manufacturer of labels, and therefore the default choice.

Criteria ____ is the term for rules by which criteria must be entered in a query.

Shape ____ make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click.

Which of the following is NOT a common report embellishment?

An absolute cell reference changes the cell references when the formula is copied to a new location.

The ____________________ Sheet is a comprehensive listing of all characteristics that have been specified for that control.

A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

This control is both a list box and a text box control.

You can edit the contents of the active cell by ____.

Which data type stores only one of two values?

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.