Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Summary reports may not contain controls in the Group Header and Footer sections.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT changed with a theme?

Accepted Answer

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

Question 6

To run a Select query, you can either click the Run button or the Execute button. ____________________

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

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

Question 10

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

Accepted Answer

The answer of The Format ____________________ is a tool used...

Question 11

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

Accepted Answer

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

Question 12

Themes can include font, color, and alignment choices.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

You might want a Group Header

Question 14

Report View does not show page margins. ____________________

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

The answer of The ____________________ New Page property helps you...

Question 16

Report section ____________________ are the characteristics that define each section.

Accepted Answer

The answer of Report section ____________________ are the characteristics that...

Question 17

Match between columns
                        Premises: 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
Changes the way a control looks on a form or report based on criteria you specify

Accepted Answer

The Answer of Format Painter and Theme and Conditional formatting is...

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

Summary reports may not contain controls in the Group Header and Footer sections.

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

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

Which of the following is NOT changed with a theme?

To run a Select query, you can either click the Run button or the Execute button. ____________________

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

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

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

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

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

Themes can include font, color, and alignment choices.

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

Report View does not show page margins. ____________________

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

Report section ____________________ are the characteristics that define each section.

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

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 8: Analyizng Data With Reports

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

Summary reports may not contain controls in the Group Header and Footer sections.

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

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

Which of the following is NOT changed with a theme?

To run a Select query, you can either click the Run button or the Execute button. ____________________

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

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

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

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

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

Themes can include font, color, and alignment choices.

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

Report View does not show page margins. ____________________

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

Report section ____________________ are the characteristics that define each section.

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

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters