Question 1

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 2

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 3

The ____ section appears at the bottom of each page of a report and is used for page numbers and brief explanations of symbols or abbreviations, among other elements.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

A custom report may be created using Layout view or Design view.

Accepted Answer

A) True 
 B)False

Question 7

Selected portions of a report may be copied to the Clipboard and pasted into a Word document when viewing a report in Report view.

Accepted Answer

A) True 
 B)False

Question 8

Live data is not visible in controls when making changes to a report in Design view.

Accepted Answer

A) True 
 B)False

Question 9

Spacing and punctuation for mailing labels is determined by spacing and punctuation inserted in the ____ box.

Accepted Answer

A) Label fields 
B) Prototype label 
C) Table fields 
D) Source label 
A) Label fields 
B) Prototype label 
C) Table fields 
D) Source label

Question 10

Describe five common enhancements and corrections that may be needed when modifying a report.

Accepted Answer

Students may choose any 5 of the 7. 
• C

Question 11

The Currency control format adds comma separators and a maximum of two decimal places.

Accepted Answer

A) True 
 B)False

Question 12

List 3 reasons to create a custom report.

Accepted Answer

1. The Report tool or Report Wizard will

Question 13

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

Accepted Answer

A) Font style 
B) Font size 
C) Font color 
D) Font weight 
A) Font style 
B) Font size 
C) Font color 
D) Font weight

Question 14

To obtain maximum report width, calculate the report width by subtracting the size of the ____ from the width of the page which will be used to view or print the report..

Accepted Answer

A) Report Header 
B) Top and Bottom margins 
C) Left and Right margins 
D) Report Header and Footer 
A) Report Header 
B) Top and Bottom margins 
C) Left and Right margins 
D) Report Header and Footer

Question 15

Which option will allow you to increase the height of the Page Header using the mouse?

Accepted Answer

A) change the Height property of the Page header section 
B) set the Can Grow property to Yes 
C) drag the Page Header border down to the desired height 
D) click on the ruler at the desired height setting 
A) change the Height property of the Page header section 
B) set the Can Grow property to Yes 
C) drag the Page Header border down to the desired height 
D) click on the ruler at the desired height setting

Question 16

Yes/no and true/false fields are represented with check boxes in a report.

Accepted Answer

A) True 
 B)False

Question 17

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

Accepted Answer

A) visible 
B) sorted 
C) similar 
D) formatted 
A) visible 
B) sorted 
C) similar 
D) formatted

Question 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

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

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

The ____ section appears at the bottom of each page of a report and is used for page numbers and brief explanations of symbols or abbreviations, among other elements.

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

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

A custom report may be created using Layout view or Design view.

Selected portions of a report may be copied to the Clipboard and pasted into a Word document when viewing a report in Report view.

Live data is not visible in controls when making changes to a report in Design view.

Spacing and punctuation for mailing labels is determined by spacing and punctuation inserted in the ____ box.

Describe five common enhancements and corrections that may be needed when modifying a report.

The Currency control format adds comma separators and a maximum of two decimal places.

List 3 reasons to create a custom report.

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

To obtain maximum report width, calculate the report width by subtracting the size of the ____ from the width of the page which will be used to view or print the report..

Which option will allow you to increase the height of the Page Header using the mouse?

Yes/no and true/false fields are represented with check boxes in a report.

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

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

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

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

Access 1: Creating Advanced Queries and Enhancing Table Design

Access 2: Using Form Tools and Creating Custom Forms

Access 4: Sharing Integrating and Analyzing Data

Excel 1: Working With Excel Tables Pivottables and Pivotcharts

Excel 2: Managing Multiple Worksheets and Workbooks

Excel 3: Developing an Excel Application

Excel 4: Working With Advanced Functions

Powerpoint 1: Applying Advanced Formatting to Objects

Powerpoint 2: Advanced Animations and Distributing Presentations

Productivity Apps for School and Work Angel

Word 1: Working With Templates Themes and Styles

Word 2: Using Mail Merge

Word 3: Collaborating With Others and Integrating Data

Filters

Exam 3: Access 3: Creating Custom Reports

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

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

The ____ section appears at the bottom of each page of a report and is used for page numbers and brief explanations of symbols or abbreviations, among other elements.

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

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

A custom report may be created using Layout view or Design view.

Selected portions of a report may be copied to the Clipboard and pasted into a Word document when viewing a report in Report view.

Live data is not visible in controls when making changes to a report in Design view.

Spacing and punctuation for mailing labels is determined by spacing and punctuation inserted in the ____ box.

Describe five common enhancements and corrections that may be needed when modifying a report.

The Currency control format adds comma separators and a maximum of two decimal places.

List 3 reasons to create a custom report.

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

To obtain maximum report width, calculate the report width by subtracting the size of the ____ from the width of the page which will be used to view or print the report..

Which option will allow you to increase the height of the Page Header using the mouse?

Yes/no and true/false fields are represented with check boxes in a report.

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

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

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

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

Access 1: Creating Advanced Queries and Enhancing Table Design

Access 2: Using Form Tools and Creating Custom Forms

Access 4: Sharing Integrating and Analyzing Data

Excel 1: Working With Excel Tables Pivottables and Pivotcharts

Excel 2: Managing Multiple Worksheets and Workbooks

Excel 3: Developing an Excel Application

Excel 4: Working With Advanced Functions

Powerpoint 1: Applying Advanced Formatting to Objects

Powerpoint 2: Advanced Animations and Distributing Presentations

Productivity Apps for School and Work Angel

Word 1: Working With Templates Themes and Styles

Word 2: Using Mail Merge

Word 3: Collaborating With Others and Integrating Data

Filters