Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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

ID: 442977 • Letter: 1

Question

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 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.

Explanation / Answer

1.

Input the data for your report

2.

Summary

3.

Group footer

4.

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

5.

Blamk report

6.

All of the above

7.

Analyzing columes of data to identify trends and patterns.

8.

Query

9.

Provide detail data in a PivotTable.

10.

All of the above.