Question 1

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 2

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

Accepted Answer

Students may choose any 5 of the 7. 
1.

Question 3

Case Based Critical Thinking Questions Case 7-1
Carlos is not familiar with creating Access reports and has asked his friend Nina to help him create some useful reports from his organic produce farm data. The organic farm currently has three tables, as illustrated below. Using the information provided, determine the best answers for the questions below.
 
Nina has completed the report Carlos requested, but she notices that the columns of the report are not spaced equally. Nina can fix this problem quickly by selecting the entire report in Design view and choosing the Equal Horizontal option from the Size/Space button on the ____ tab.

Accepted Answer

A)  DESIGN 
B)  PAGE SETUP 
C)  FORMAT 
D)  ARRANGE 
A)  DESIGN 
B)  PAGE SETUP 
C)  FORMAT 
D)  ARRANGE

Question 4

Case Based Critical Thinking Questions Case 7- 2
Janise often has requests for specific pet sitters when clients request services. She has created a report that shows the sitter preferred by each client as well as the pet names, pet type, and special requests by the clients. Janise will keep the report handy in digital and printed form for reference when clients call so that she can offer personalized service to her clients. To make the report more user-friendly, Janise needs to make some adjustments.
To further personalize her pet sitting service, Janise has decided to mail each client a postcard with a 10% discount for the month of each pet's birthday. She will be creating mailing labels from her Clients table. Janise will set the formatting for the mailing labels in the ____ of the Label Wizard.

Accepted Answer

A)  Available fields box 
B)  Number across box 
C)  Prototype label box 
D)  Label type box 
A)  Available fields box 
B)  Number across box 
C)  Prototype label box 
D)  Label type box

Question 5

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

Accepted Answer

A)  DESIGN 
B)  ARRANGE 
C)  FORMAT 
D)  PAGE SETUP 
A)  DESIGN 
B)  ARRANGE 
C)  FORMAT 
D)  PAGE SETUP

Question 6

To begin the process of removing the default alternate row color in a report, select the ____ Border Style after selecting all sections of the report from the FORMAT tab.

Accepted Answer

A)  Solid 
B)  Transparent 
C)  None 
D)  All 
A)  Solid 
B)  Transparent 
C)  None 
D)  All

Question 7

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 8

Records in a report may be sorted using only one sort field.

Accepted Answer

A) True 
 B)False

Question 9

Properties of a multiple-column report may be changed using the ____________________ section of the Page Setup dialog box.

Accepted Answer

The answer of Properties of a multiple-column report may be...

Question 10

The ____________________ section in Design view appears at the top of each page of a report and usually contains page numbers, column headings, report titles, and report dates.

Accepted Answer

The answer of The ____________________ section in Design view appears...

Question 11

The format for a label is displayed in the Prototype label box when using the ____.

Accepted Answer

A)  Label Wizard 
B)  Repot Wizard 
C)  Form Wizard 
D)  Custom Label Wizard 
A)  Label Wizard 
B)  Repot Wizard 
C)  Form Wizard 
D)  Custom Label Wizard

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

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

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

To begin the process of removing the default alternate row color in a report, select the ____ Border Style after selecting all sections of the report from the FORMAT tab.

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

Records in a report may be sorted using only one sort field.

Properties of a multiple-column report may be changed using the ____________________ section of the Page Setup dialog box.

The ____________________ section in Design view appears at the top of each page of a report and usually contains page numbers, column headings, report titles, and report dates.

The format for a label is displayed in the Prototype label box when using the ____.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 3: Access: Creating Custom Reports

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

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

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

To begin the process of removing the default alternate row color in a report, select the ____ Border Style after selecting all sections of the report from the FORMAT tab.

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

Records in a report may be sorted using only one sort field.

Properties of a multiple-column report may be changed using the ____________________ section of the Page Setup dialog box.

The ____________________ section in Design view appears at the top of each page of a report and usually contains page numbers, column headings, report titles, and report dates.

The format for a label is displayed in the Prototype label box when using the ____.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters