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