Deck 8: Analyzing Data With Reports Question

Question 1

Report sections have properties.

Answer 1

True

Question 2

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

Answer 2

D

Question 3

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

Answer 3

True

Question 4

You can print data from forms, datasheets, or reports.

Question 5

It is necessary for every report to have at least a Report Header and Report Footer section.

Question 6

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

Question 7

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

Question 8

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

Question 9

One feature of a report is that it gives you flexibility in presenting summary information.

Question 10

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

Question 11

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

Question 12

In the figure above, selecting a theme using the button identified as item 1 will apply the theme to all existing reports and forms in the database.

Question 13

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

Question 14

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

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

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

Question 17

Themes can include font, color, and alignment choices.

Question 18

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

Question 19

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

Question 20

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 21

In the figure above, the ____ is the currently selected control.

A)Cost label
B)Cost text box
C)Detail section
D)Report1 report

Question 22

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 23

In the figure above, what type of control is not found in the Category Footer section?

A)Label
B)Combo box
C)Line
D)Text box

Question 24

In the figure above, item 4 helps you ____.

A)set the report theme
B)define property values
C)set the sort order
D)add fields to the report

Question 25

Which of the following is NOT an option in the Conditional Formatting Rule 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 26

When building a report in Report Design View, the most likely first step is to ___________.

A)apply the theme
B)identify the record source
C)set the margins
D)add lines to separate the sections

Question 27

In the figure above, 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 28

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

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

Question 29

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

A)One
B)Two
C)Three
D)Four

Question 30

In the figure above, what is the grouping field?

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

Question 31

In the figure above, item 5 helps you____.

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

Question 32

Which report section prints once for every record?

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

Question 33

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 34

In the figure above, item 3 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 35

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 36

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 37

A parameter report is 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 38

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 39

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 40

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 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

In the figure above, what kind of control is not found in the Report Footer section?

A)Label
B)Line
C)Text Box
D)Section

Question 46

Report section ____________________  are the characteristics that define each section.

Question 47

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 48

Default margins are often 0.25 inches in Report Design View.For a report printed in Portrait orientation on 8.5x11" paper, this means that the report can be no wider than ____.

A)10.5 inches
B)8 inches
C)11 inches
D)The paper

Question 49

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

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

Question 50

In the figure above, the report would most likely be called a _______ report.

A)Parameter
B)Summary
C)Subreport
D)Theme

Question 51

The ____________________  object gives you more control over how data is printed than forms and datasheets.

Question 52

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

Question 53

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

Question 54

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 55

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

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

Question 56

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

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

Question 57

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

Question 58

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

Question 59

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

A)Control
B)Main
C)Parent
D)Property

Question 60

To create a summary report, delete all of the controls in this section of the report.

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

Question 61

You could use a subreport control to change the order in which information normally prints.

Question 62

A theme displays a report within another report.

Question 64

Identify at least two major ways you can improve report formatting productivity.

Question 65

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

Question 66

Report section properties cannot be modified to improve report printouts.

Question 67

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

Question 68

In the figure above, 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 69

How are lines used in a typical Access report?

Question 70

Why would you use a subreport control?

Question 71

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