Question 1

How are lines used in a typical Access report?

Accepted Answer

Lines are used to visually sep

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 above 
A)  open Group Header and Footer sections 
B)  add grouping fields 
C)  set sort orders 
D)  All of the above

Question 10

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

Accepted Answer

The answer of ____________________ formatting allows you to change the...

Question 11

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

Accepted Answer

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

Question 12

Report section properties cannot be modified to improve report printouts.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

The Answer of Conditional formatting and Parameter report and Format is...

Question 15

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 16

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

Accepted Answer

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

Question 17

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 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of ____________________ are predefined formats that you apply...

Question 20

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

Accepted Answer

A) True 
 B)False

How are lines used in a typical Access report?

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

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

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

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

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

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

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

In the accompanying figure, item 2 helps you ____.

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

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

Report section properties cannot be modified to improve report printouts.

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?

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

What type of line under a value indicates grand totals?

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

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

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyzing Data With Reports

Filters

Exam 8: Enhancing Forms

How are lines used in a typical Access report?

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

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

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

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

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

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

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

In the accompanying figure, item 2 helps you ____.

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

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

Report section properties cannot be modified to improve report printouts.

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?

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

What type of line under a value indicates grand totals?

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

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

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyzing Data With Reports

Filters