Question 1

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

Accepted Answer

1.Use conditional formatting to highlight important or exceptional data
2.Use the Format Painter to copy and paste formats
3.Use themes to apply predefined formatting embellishments to the entire database.

Question 2

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 Header D

Question 3

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.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of ____________ reports are reports that show statistics...

Question 10

In the figure above, item 4 helps you ____.

Accepted Answer

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

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

Question 12

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

Question 13

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 14

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

Accepted Answer

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

Question 15

Why would you use a subreport control?

Accepted Answer

The answer of Why would you use a subreport control?...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

Match between columns
                        Premises: Changes the way a control looks on a form or report based on criteria you specify
Predefined format that you can apply to all objects in the database
Shows statistics on groups of records
Prompts the user for criteria to select records for a report
Copies formatting properties from one control to another

Accepted Answer

The Answer of Theme and Parameter report and Summary report is...

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 8: Analyzing Data With Reports Question

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

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

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.

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

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

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

In the figure above, item 3 helps you____.

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

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

In the figure above, item 4 helps you ____.

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

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

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

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

Why would you use a subreport control?

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

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

Match each term with its correct description.

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

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