1. Which of the following is not a step in designing a report?

Create a sketch of your report.

Identify the record source and fields for your report.

Input the data for your report.

Determine sorts, groups, and summaries for your report.

2. Which of the following is NOT a Report Wizard Layout type?

Block

Outline

Stepped

Summary

3. Which report section would be used to summarize grouped field data?

Detail

Group Header

Group Footer

Report Footer

4. The following steps will create a report.

Set focus on a table or query object, click on the Create tab, then click the Report button in the Reports group.

Set focus on a table or query object, click on the Design tab, open the table or query object, then click Design Report.

Click on the Create tab, select the Report Wizard, select your tables or queries, and then your fields.

Click on the Table tab, select your fields, and then click the Finish button.

5. A tool that creates a report through a series of dialog boxes on the Create tab is the

Blank Report.

Label Wizard.

Report.

Report Wizard.

6. Modifications to a report can be done in

Detail View.

Layout View.

Print View.

All of the above

7. Data mining refers to

analyzing volumes of data to identify trends and patterns.

conducting what if analyses.

analyzing minute differences in field data.

the least squares regression technique to forecast data trends.

8. PivotTables and PivotCharts that summarize data based on multiple sources use a

form.

query.

report.

table.

9. A Drill button is used to

collapse and expand groups in a scatter chart.

filter data in an area chart.

hide information in a line chart.

provide detail data in a PivotTable.

10. A popular PivotChart that is used in Access is

column.

line.

pie.

All of the above