Question 1

-In Report Design View, if you want to view the grouping and sorting fields, click the ____.

Accepted Answer

A)  Footer button 
B)  Sections button 
C)  Group & Sort button 
D)  Text Box button 
A)  Footer button 
B)  Sections button 
C)  Group & Sort button 
D)  Text Box button

Question 2

To create a summary report, you should delete all of the controls in the ____ section of the report.

Accepted Answer

A)  Group Footer 
B)  Group Header 
C)  Detail 
D)  Report Footer 
A)  Group Footer 
B)  Group Header 
C)  Detail 
D)  Report Footer

Question 3

Report section ____________________ are the characteristics that define each section.

Accepted Answer

The answer of Report section ____________________ are the characteristics that...

Question 4

-In the accompanying figure, why might the controls in the Report Header section be selected?

Accepted Answer

A)  to create a calculated field 
B)  to add a subform 
C)  to add a text box 
D)  to remove a report layout 
A)  to create a calculated field 
B)  to add a subform 
C)  to add a text box 
D)  to remove a report layout

Question 5

Report sections have properties.

Accepted Answer

A) True 
 B)False

Question 6

The Format ____________________ is a tool used to copy formatting properties from one control to another.

Accepted Answer

The answer of The Format ____________________ is a tool used...

Question 7

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

Accepted Answer

A)  parameter report 
B)  subreport 
C)  main report 
D)  summary report 
A)  parameter report 
B)  subreport 
C)  main report 
D)  summary report

Question 8

-In the accompanying figure, click item 5 to add a _____ to a report.

Accepted Answer

A)  label 
B)  text box 
C)  sort order 
D)  subreport 
A)  label 
B)  text box 
C)  sort order 
D)  subreport

Question 9

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

Accepted Answer

A) True 
 B)False

Question 10

-Jim builds the report shown in the accompanying figure. How has Jim grouped the records and what does that tell you about the information he is trying to emphasize in this report?

Accepted Answer

The records are currently grou

Question 11

Which report section is most commonly used to calculate a summary statistic on a group of records?

Accepted Answer

A)  Detail 
B)  Group Footer 
C)  Page Footer 
D)  Calculation Footer 
A)  Detail 
B)  Group Footer 
C)  Page Footer 
D)  Calculation Footer

Question 12

Match each term with its correct description.
-Shows statistics on groups of records

Accepted Answer

A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme 
A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme

Question 13

-In the accompanying figure, click the button identified as item 1 to change the Force New Page property.

Accepted Answer

A) True 
 B)False

Question 14

-In the accompanying figure, item 5 helps you ____.

Accepted Answer

A)  add controls to the report that are not currently visible 
B)  set the tab order for the report 
C)  set sorting and grouping fields 
D)  enter expressions for calculations 
A)  add controls to the report that are not currently visible 
B)  set the tab order for the report 
C)  set sorting and grouping fields 
D)  enter expressions for calculations

Question 15

Which of the following is not a category tab in the Property Sheet?

Accepted Answer

A)  Print 
B)  Format 
C)  Data 
D)  All 
A)  Print 
B)  Format 
C)  Data 
D)  All

Question 16

In Report Design View, lines can be difficult to find when they are against the edge of a section or the edge of another control.

Accepted Answer

A) True 
 B)False

Question 17

-In the accompanying figure, what field is used as the grouping field?

Accepted Answer

A)  Category 
B)  TourName 
C)  CustNo 
D)  SaleDate 
A)  Category 
B)  TourName 
C)  CustNo 
D)  SaleDate

Question 18

You can add ____ conditional format(s) for any combination of selected controls.

Accepted Answer

A)  One 
B)  Two 
C)  Multiple 
D)  Currency 
A)  One 
B)  Two 
C)  Multiple 
D)  Currency

Question 19

It is necessary to keep all of the report sections the same height in order for the report to display properly.

Accepted Answer

A) True 
 B)False

Question 20

Match each term with its correct description.
-Prompts the user for criteria to select records for a report

Accepted Answer

A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme 
A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme

-In Report Design View, if you want to view the grouping and sorting fields, click the ____.

To create a summary report, you should delete all of the controls in the ____ section of the report.

Report section ____________________ are the characteristics that define each section.

-In the accompanying figure, why might the controls in the Report Header section be selected?

Report sections have properties.

The Format ____________________ is a tool used to copy formatting properties from one control to another.

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

-In the accompanying figure, click item 5 to add a _____ to a report.

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

-Jim builds the report shown in the accompanying figure. How has Jim grouped the records and what does that tell you about the information he is trying to emphasize in this report?

Which report section is most commonly used to calculate a summary statistic on a group of records?

Match each term with its correct description. -Shows statistics on groups of records

-In the accompanying figure, click the button identified as item 1 to change the Force New Page property.

-In the accompanying figure, item 5 helps you ____.

Which of the following is not a category tab in the Property Sheet?

In Report Design View, lines can be difficult to find when they are against the edge of a section or the edge of another control.

-In the accompanying figure, what field is used as the grouping field?

You can add ____ conditional format(s) for any combination of selected controls.

It is necessary to keep all of the report sections the same height in order for the report to display properly.

Match each term with its correct description. -Prompts the user for criteria to select records for a report

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 9: Analyzing Data With Reports

-In Report Design View, if you want to view the grouping and sorting fields, click the ____.

To create a summary report, you should delete all of the controls in the ____ section of the report.

Report section ____________________ are the characteristics that define each section.

-In the accompanying figure, why might the controls in the Report Header section be selected?

Report sections have properties.

The Format ____________________ is a tool used to copy formatting properties from one control to another.

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

-In the accompanying figure, click item 5 to add a _____ to a report.

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

-Jim builds the report shown in the accompanying figure. How has Jim grouped the records and what does that tell you about the information he is trying to emphasize in this report?

Which report section is most commonly used to calculate a summary statistic on a group of records?

Match each term with its correct description. -Shows statistics on groups of records

-In the accompanying figure, click the button identified as item 1 to change the Force New Page property.

-In the accompanying figure, item 5 helps you ____.

Which of the following is not a category tab in the Property Sheet?

In Report Design View, lines can be difficult to find when they are against the edge of a section or the edge of another control.

-In the accompanying figure, what field is used as the grouping field?

You can add ____ conditional format(s) for any combination of selected controls.

It is necessary to keep all of the report sections the same height in order for the report to display properly.

Match each term with its correct description. -Prompts the user for criteria to select records for a report

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters