Exam 2: Getting Started With Access 2.0

____ are rules or limiting conditions you set to determine which records will be selected in a filter or query.

To add a table's field list to the upper pane of Query Design View, click the   ____________________ Table button.

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

Press this keystroke combination to move focus to the last field of the last record.

In the formula =ROUND(D4:F4,0), what does the zero indicate?

You can resize form sections in Form Design View.

Use this form creation tool to create a form from scratch in Form Design View.

In Query Design View, the query design ____________________ shows you the fields that you have requested for the query.

____ marks indicate the scale of measure for each value on the y-axis.

In Page Layout view, the dotted line indicates the print area.

A primary key field uniquely identifies each record.

Which report view's primary purpose is to quickly review the first page of the report?

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

Following the order of precedence, a formula calculates addition first, then multiplication.

The Navigation tab on the Property Sheet allows you to change the tab stop or tab order properties.

Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet.

How do you format a cell or range?

Discuss the meanings of calculation, expression, function, and argument.

When referencing field names within an expression, surround the field name with ____.

A(n) ____ identifies each data series in a chart, generally with a different color.