Question 1

To zoom in or out when viewing a report, use ____________________ to view the report.

Accepted Answer

Print Preview

Question 2

What is the maximum number of sort fields that can be included in a report?

Accepted Answer

A) 5 
B) 10 
C) 12 
D) unlimited 
A) 5 
B) 10 
C) 12 
D) unlimited B

Question 3

The Line tool is accessed using the More button in the ____ group on the Design tab.

Accepted Answer

A) Header/Footer 
B) Themes 
C) Tools 
D) Controls 
A) Header/Footer 
B) Themes 
C) Tools 
D) Controls D

Question 4

To modify a report while viewing actual report data, use the ____ view.

Accepted Answer

A) Layout 
B) Design 
C) Print Preview 
D) Report 
A) Layout 
B) Design 
C) Print Preview 
D) Report

Question 5

The Group, Sort, and Total pane is used to select sort fields and grouping fields for a report. ____________________

Accepted Answer

A) True 
 B)False

Question 6

Common properties for multiple controls may be set by performing which of the following tasks?

Accepted Answer

A) select each control separately and change the properties 
B) select adjacent controls only using the Ctrl key and the mouse; then change the properties for adjacent controls one at a time 
C) select adjacent and nonadjacent controls using the Ctrl key and the mouse; then change the properties for all controls at once 
D) change the properties to apply to all controls then select the controls by clicking on the controls with the mouse 
A) select each control separately and change the properties 
B) select adjacent controls only using the Ctrl key and the mouse; then change the properties for adjacent controls one at a time 
C) select adjacent and nonadjacent controls using the Ctrl key and the mouse; then change the properties for all controls at once 
D) change the properties to apply to all controls then select the controls by clicking on the controls with the mouse

Question 7

Layout view must be used to select all controls in a report and to remove an individual control from the selection. ____________________

Accepted Answer

A) True 
 B)False

Question 8

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

Accepted Answer

A) padding 
B) keep whole group together on one page 
C) keep header and first record together on one page 
D) do not keep group together on one page 
A) padding 
B) keep whole group together on one page 
C) keep header and first record together on one page 
D) do not keep group together on one page

Question 9

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report. ____________________

Accepted Answer

A) True 
 B)False

Question 10

The Page Numbers button, used to add a page number expression to a report, is found in the ____ group on the Design tab.

Accepted Answer

A) Header/Footer 
B) Arrange 
C) Tools 
D) Theme 
A) Header/Footer 
B) Arrange 
C) Tools 
D) Theme

Question 11

Which control format property adds comma separators and two decimal places in report Design view.

Accepted Answer

A) Standard 
B) Currency 
C) Fixed 
D) General Number 
A) Standard 
B) Currency 
C) Fixed 
D) General Number

Question 12

A sort field must also be designated as a____________________field in order to include a Group Header and a Group Footer section in the report for a group.

Accepted Answer

The answer of A sort field must also be designated...

Question 13

Labels can only be printed in an Access report using the across, then down sequence. ____________________

Accepted Answer

A) True 
 B)False

Question 14

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

Accepted Answer

A) Wizard 
B) custom 
C) grid 
D) auto 
A) Wizard 
B) custom 
C) grid 
D) auto

Question 15

The Detail Section of a report usually contains most of the report contents. ____________________

Accepted Answer

A) True 
 B)False

Question 16

A ____________________ report prints the same collection of field values in two or more sets across a page.

Accepted Answer

The answer of A ____________________ report prints the same collection...

Question 17

A field's data type and the selected value determine the ____ options that appear on the shortcut menu in Report view.

Accepted Answer

A) control 
B) filter 
C) preview 
D) properties 
A) control 
B) filter 
C) preview 
D) properties

Question 18

The ____________________ option from the Size/Space button on the ARRANGE tab creates equal spacing between horizontal controls.

Accepted Answer

The answer of The ____________________ option from the Size/Space button...

Question 19

A text box that is too narrow to display the full field value will display the pound sign (#), which means the ____ of the text box must be adjusted.

Accepted Answer

A) height 
B) position 
C) width 
D) format 
A) height 
B) position 
C) width 
D) format

Question 20

To set a report's margins to Wide with 1" top and bottom margins and 0.75 left and right margins, click on the Margins button on the ____ tab in Report Design Tools.

Accepted Answer

A) Format 
B) Print 
C) Arrange 
D) Page Setup 
A) Format 
B) Print 
C) Arrange 
D) Page Setup

To zoom in or out when viewing a report, use ____________________ to view the report.

What is the maximum number of sort fields that can be included in a report?

The Line tool is accessed using the More button in the ____ group on the Design tab.

To modify a report while viewing actual report data, use the ____ view.

The Group, Sort, and Total pane is used to select sort fields and grouping fields for a report. ____________________

Common properties for multiple controls may be set by performing which of the following tasks?

Layout view must be used to select all controls in a report and to remove an individual control from the selection. ____________________

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report. ____________________

The Page Numbers button, used to add a page number expression to a report, is found in the ____ group on the Design tab.

Which control format property adds comma separators and two decimal places in report Design view.

A sort field must also be designated as a____________________field in order to include a Group Header and a Group Footer section in the report for a group.

Labels can only be printed in an Access report using the across, then down sequence. ____________________

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

The Detail Section of a report usually contains most of the report contents. ____________________

A ____________________ report prints the same collection of field values in two or more sets across a page.

A field's data type and the selected value determine the ____ options that appear on the shortcut menu in Report view.

The ____________________ option from the Size/Space button on the ARRANGE tab creates equal spacing between horizontal controls.

A text box that is too narrow to display the full field value will display the pound sign (#), which means the ____ of the text box must be adjusted.

To set a report's margins to Wide with 1" top and bottom margins and 0.75 left and right margins, click on the Margins button on the ____ tab in Report Design Tools.

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 7: Creating Custom Reports

To zoom in or out when viewing a report, use ____________________ to view the report.

What is the maximum number of sort fields that can be included in a report?

The Line tool is accessed using the More button in the ____ group on the Design tab.

To modify a report while viewing actual report data, use the ____ view.

The Group, Sort, and Total pane is used to select sort fields and grouping fields for a report. ____________________

Common properties for multiple controls may be set by performing which of the following tasks?

Layout view must be used to select all controls in a report and to remove an individual control from the selection. ____________________

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report. ____________________

The Page Numbers button, used to add a page number expression to a report, is found in the ____ group on the Design tab.

Which control format property adds comma separators and two decimal places in report Design view.

A sort field must also be designated as a____________________field in order to include a Group Header and a Group Footer section in the report for a group.

Labels can only be printed in an Access report using the across, then down sequence. ____________________

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

The Detail Section of a report usually contains most of the report contents. ____________________

A ____________________ report prints the same collection of field values in two or more sets across a page.

A field's data type and the selected value determine the ____ options that appear on the shortcut menu in Report view.

The ____________________ option from the Size/Space button on the ARRANGE tab creates equal spacing between horizontal controls.

A text box that is too narrow to display the full field value will display the pound sign (#), which means the ____ of the text box must be adjusted.

To set a report's margins to Wide with 1" top and bottom margins and 0.75 left and right margins, click on the Margins button on the ____ tab in Report Design Tools.

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters