Deck 9: Analyzing Data With Reports

Question 1

Conditional formatting allows you to compare the values of one column to another with small data bars.

Answer 1

True

Question 2

In Access parameter reports, you can shorten date criteria by entering only two digits for the year instead of four.

Answer 2

True

Question 3

Report sections have properties.

Answer 3

True

Question 4

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

Question 5

The Group, Sort, and Total pane allows you to open group header and footer sections.

Question 6

In a report, label controls display data from underlying fields.

Question 7

To move a control from one report section to another, use cut and paste.

Question 8

In the accompanying figure, how many controls are in the Category Header section?

A) 1
B) 2
C) 7
D) 8

Question 9

Report Design View gives you full control of all aspects of a report.

Question 10

Double-clicking the Format Painter button formats all controls in that section with the formatting characteristics of the currently selected control.

Question 11

It is necessary for each report to have at least one control in the Detail section.

Question 12

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

Question 13

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

A) Macros
B) Modules
C) Queries
D) Reports

Question 14

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

Question 15

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

Question 16

Themes can include font, color, and alignment choices.

Question 17

You can use the Format Painter to format lines, labels, and text boxes.

Question 18

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

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

Question 19

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.

Question 20

In the accompanying figure, what is the grouping field?

A) Category
B) TourNo
C) TourName
D) Cost

Question 21

Which report section prints once for every record?

A) Record
B) Group
C) Detail
D) Page

Question 22

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

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

Question 23

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

A) Report Header
B) Category Header
C) TourName Footer
D) Report Footer

Question 24

In the accompanying figure, item 2 helps you ____.

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

Question 25

In the accompanying figure, what type of control is NOT found in the Page Header section?

A) Label
B) Combo box
C) All of these controls are found in the Page Header section
D) Text box

Question 26

Which report section is most commonly used for titles, dates, and page numbers?

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

Question 27

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

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

Question 28

You create a parameter report based on a parameter query by setting the report's ____ property.

A) Recordset
B) Group Controls
C) Record Source
D) None of the above.

Question 29

Which of the following is NOT an option in the Conditional Formatting Rules Manager dialog box?

A) Defining the rules.
B) Defining the formats.
C) Determining which control to conditionally format.
D) Changing the value of the control.

Question 30

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

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

Question 31

Which report section would be the most logical choice to use for the report title or logo?

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

Question 32

In the accompanying figure, item 5 helps you ____.

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 33

In the accompanying figure, item 5 helps you ____.

A) add fields
B) set the database theme
C) add controls
D) add lines

Question 34

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

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

Question 35

You enter parameter criteria in Query Design View inside of ____.

A) [square brackets]
B) {curly brackets}
C) (parentheses)
D) "quotation marks"

Question 36

Which section prints at the top of the first page of the report?

A) Report Header
B) Page Header
C) Section Header
D) Group Header

Question 37

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

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

Question 38

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

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

Question 39

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

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

Question 40

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

A) Subreport
B) Parameter report
C) Main report
D) Query

Question 41

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

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

Question 42

Which of the following is NOT changed with a theme?

A) fonts
B) colors
C) field values
D) control alignment

Question 43

Summary reports typically have no controls in which section?

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

Question 44

____________________ reports are reports that show statistics on groups of records rather than detailed information.

Question 45

In the accompanying figure, text boxes are positioned in the ____________________ section.

Question 46

What type of line under a value indicates grand totals?

A) A bold line of any color.
B) A thick red line.
C) A thick blue line.
D) Double lines.

Question 47

The ____________________ New Page property helps you start printing a section at the top of a new page.

Question 48

____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.

Question 49

A report that contains a subreport is called the ____ report.

A) control
B) main
C) parent
D) property

Question 50

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

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

Question 51

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?

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

Question 52

Short double lines under the calculations in the Report Footer section indicate ____.

A) changed data
B) grand totals
C) exceptional conditions
D) conditional formatting

Question 53

Report section ____________________ are the characteristics that define each section.

Question 54

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

Question 55

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

Question 56

Which control is used to add a report to another report?

A) text box
B) combo box
C) subreport
D) group section

Question 57

____________________ are predefined formats that you apply to the database to set all of the formatting enhancements such as font, color, and alignment.

Question 58

Which key do you press and hold to create a perfectly horizontal line?

A) [Alt]
B) [Ctrl]
C) [Shift]
D) [Caps Lock]

Question 59

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

Question 60

A(n) ____________________ gives you more control over how data is printed than forms and datasheets.

Question 61

The report that contains the subreport control is called the main report. _________________________

Question 62

Match each term with its correct description.
a.Summary report
d.Format Painter
b.Parameter report
e.Theme
c.Conditional formatting
Copies formatting properties from one control to another

Question 63

A(n) theme displays a report within another report. _________________________

Question 64

Match each term with its correct description.
a.Summary report
d.Format Painter
b.Parameter report
e.Theme
c.Conditional formatting
Changes the way a control looks on a form or report based on criteria you specify

Question 65

How are lines used in a typical Access report?

Question 66

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

Question 67

You can use a(n) subreport control to change the order in which information prints. _________________________

Question 68

Kelsey uses Access to track the sales by category for each tour. Referring to the accompanying figure, what is the name of the field she should use in an expression to total the sales?

Question 69

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

Question 70

In the accompanying figure, the expression =Sum([Revenue]) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.

Question 71

Match each term with its correct description.
a.Summary report
d.Format Painter
b.Parameter report
e.Theme
c.Conditional formatting
Shows statistics on groups of records

Question 72

Match each term with its correct description.
a.Summary report
d.Format Painter
b.Parameter report
e.Theme
c.Conditional formatting
Predefined format that you can apply to all objects in the database

Question 73

Match each term with its correct description.
a.Summary report
d.Format Painter
b.Parameter report
e.Theme
c.Conditional formatting
Prompts the user for criteria to select records for a report

Question 74

You modify the Set New Page property of a section to force each section to start printing at the top of a new page. _________________________

Question 75

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

Question 76

The Theme Painter is a tool you use to copy multiple formatting properties from one control to another. _________________________

Question 77

Discuss two reasons you might want to modify section properties in a report.

Question 78

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

Question 79

Why might you want to use a subreport control?

Question 80

Parameter formatting allows you to change the appearance of a control on a form or report based on criteria you specify. _________________________