Question 1

Match each term with its correct description.
-Predefined format that you can apply to all objects in the database

Accepted Answer

A)  Summary report
B)  Parameter report
C)  Conditional formatting
D)  Format Painter
E)  ThemeF) None of the above
G) C) and D)

Question 2

It is necessary for every report to have Report Header and Report Footer sections.

Accepted Answer

A) True 
 B)False

Question 3

-In the accompanying figure, which section does not contain any controls?

Accepted Answer

A)   Report Header
B)   Category Header
C)   TourName Footer
D)   Report FooterE) B) and C)
F) A) and D)

Question 4

Match each term with its correct description.
-Changes the way a control looks on a form or report based on criteria you specify

Accepted Answer

A)  Summary report
B)  Parameter report
C)  Conditional formatting
D)  Format Painter
E)  ThemeF) A) and B)
G) A) and C)

Question 5

You enter criteria in the Enter Parameter Value box for a parameter report. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

Accepted Answer

The answer of Report ____________________ View allows you to work...

Question 7

Report section properties cannot be modified to improve report printouts. _________________________

Accepted Answer

A) True 
 B)False

Question 8

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

Accepted Answer

A)   Macros
B)   Modules
C)   Queries
D)   ReportsE) All of the above
F) B) and C)

Question 9

A ____ prompts you for criteria to determine the records to use for the report.

Accepted Answer

A)   Subreport
B)   Parameter report
C)   Main report
D)   QueryE) A) and C)
F) B) and D)

Question 10

Match each term with its correct description.
-Copies formatting properties from one control to another

Accepted Answer

A)  Summary report
B)  Parameter report
C)  Conditional formatting
D)  Format Painter
E)  ThemeF) B) and E)
G) A) and E)

Question 11

To create a report that shows only group summary information, delete all of the controls in the ____________________ section.

Accepted Answer

The answer of To create a report that shows only...

Question 12

The report's ____ property determines what table or query provides the fields and records for a report.

Accepted Answer

A)   Parameter
B)   Record Source
C)   Conditional Formatting
D)   Group and SortE) B) and C)
F) B) and D)

Question 13

Which report section would be the most logical choice to display the grouping field value?

Accepted Answer

A)   Report Header
B)   Page Header
C)   Detail Header
D)   Group HeaderE) A) and B)
F) B) and D)

Question 14

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

Accepted Answer

A)   Category
B)   TourNo
C)   TourName
D)   CostE) A) and D)
F) None of the above

Question 15

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

Accepted Answer

A)   open Group Header and Footer sections
B)   add grouping fields
C)   set sort orders
D)   All of the aboveE) A) and B)
F) A) and C)

Question 16

To create a parameter report, you base it on a parameter table. _________________________

Accepted Answer

A) True 
 B)False

Question 17

You use conditional formatting to highlight important data in a report.

Accepted Answer

A) True 
 B)False

Question 18

What type of line under a value indicates grand totals?

Accepted Answer

A)   A bold line of any color.
B)   A thick red line.
C)   A thick blue line.
D)   Double lines.E) A) and B)
F) None of the above

Question 19

Why might you want to use a subreport control?

Accepted Answer

You use the subreport control ...

Question 20

-Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

Accepted Answer

Doug grouped the records by To...

Exam 9: Analyzing Data With Reports

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

Correct AnswerverifiedShow Answer

-In the accompanying figure, which section does not contain any controls?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

It is necessary for every report to have Report Header and Report Footer sections.

Correct AnswerverifiedShow Answer

-Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

Correct AnswerverifiedDoug grouped the records by To...View AnswerShow Answer

A ____ prompts you for criteria to determine the records to use for the report.

Correct AnswerverifiedShow Answer

To create a parameter report, you base it on a parameter table. _________________________

Correct AnswerverifiedShow Answer

You use conditional formatting to highlight important data in a report.

Correct AnswerverifiedShow Answer

Match each term with its correct description. -Changes the way a control looks on a form or report based on criteria you specify

Correct AnswerverifiedShow Answer

You enter criteria in the Enter Parameter Value box for a parameter report. _________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Report section properties cannot be modified to improve report printouts. _________________________

Correct AnswerverifiedShow Answer

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

Correct AnswerverifiedShow Answer

Match each term with its correct description. -Predefined format that you can apply to all objects in the database

Correct AnswerverifiedShow Answer

The report's ____ property determines what table or query provides the fields and records for a report.

Correct AnswerverifiedShow Answer

To create a report that shows only group summary information, delete all of the controls in the ____________________ section.

Correct AnswerverifiedShow Answer

Why might you want to use a subreport control?

Correct AnswerverifiedYou use the subreport control ...View AnswerShow Answer

Which report section would be the most logical choice to display the grouping field value?

Correct AnswerverifiedShow Answer

Match each term with its correct description. -Copies formatting properties from one control to another

Correct AnswerverifiedShow Answer

What type of line under a value indicates grand totals?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Doug grouped the records by To...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
You use the subreport control ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified