Exam 2: Getting Started With Access 2.0

Use the alignment buttons on the Design tab to align the content of a control within its own border. _________________________

To move fields in the query grid, drag the field ____________________.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

Any data changed in the worksheet is automatically updated in the chart.

Explain why you would add colors, patterns, and borders to a worksheet.

You can change the font and font size of any cell or range using the Mini toolbar.

Each time a query is opened, it displays a current view of the latest updates to the database.

You may apply multiple grouping orders to a report.

The Database window displays the Tables, Queries, Forms, and Reports. Describe what these four objects represent.

In a pie chart, you can emphasize one data point by plotting , or pulling that slice away from, the pie chart.

The ____________________ function specifies the number of decimal places to be used for values and formulas.

Functions inserted from the Insert Functions button and from the SUM list require the Excel user to type the = sign for each formula.

You can use the ______________ slider on the status bar to enlarge your view of specific areas of your worksheet.

Which section prints below the Report Header on page one?

A(n) ____ chart compares distinct object levels using vertical bars; is the Excel default.

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Which chart type would be the best candidate to emphasize sales trends over a period of 6 months?

Which control is most commonly placed in the Detail section of a report?

The Show Margins button is shown in which location of Backstage view?

No two records can have the same value in the primary key field.