Question 1

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

Accepted Answer

The answer of A(n) ____________________ gives you more control over...

Question 2

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. 
A)  A bold line of any color. 
B)  A thick red line. 
C)  A thick blue line. 
D)  Double lines.

Question 3

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 4

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

Accepted Answer

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

Question 5

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 6

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

You might want a Group Header

Question 9

In the accompanying figure, item 5 helps you ____.

Accepted Answer

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

Question 10

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

Accepted Answer

The answer of   In the accompanying figure, text...

Question 11

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 12

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 13

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

Accepted Answer

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

Question 14

Themes can include font, color, and alignment choices.

Accepted Answer

A) True 
 B)False

Question 15

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 
A)  Report Header 
B)  Page Header 
C)  Detail Header 
D)  Group Header

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

How are lines used in a typical Access report?

Accepted Answer

Lines are used to visually sep

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

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

What type of line under a value indicates grand totals?

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

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

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

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?

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

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

In the accompanying figure, item 5 helps you ____.

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

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?

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 would be the most logical choice to use for the report title or logo?

Themes can include font, color, and alignment choices.

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

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

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

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

How are lines used in a typical Access report?

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

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 8: Analyzing Data With Reports

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

What type of line under a value indicates grand totals?

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

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

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

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?

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

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

In the accompanying figure, item 5 helps you ____.

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

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?

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 would be the most logical choice to use for the report title or logo?

Themes can include font, color, and alignment choices.

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

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

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

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

How are lines used in a typical Access report?

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

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters