Question 1

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 2

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 3

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 4

A field used to group the detail items in a report.

Accepted Answer

A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header 
A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header

Question 5

Values in a selected column may be summarized using any of eight ____________________ functions on the Totals menu from the DESIGN tab.

Accepted Answer

The answer of Values in a selected column may be...

Question 6

Design view should be used to modify a report when the user wants to add lines,rectangles,and other controls only available in Design view.____________________

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

Accepted Answer

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

Question 11

The section of a report that usually displays subtotals or counts for records in a group.

Accepted Answer

A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header 
A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A section that appears by itself at the bottom of a page.

Accepted Answer

A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header 
A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header

Question 14

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 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

The answer of To zoom in or out when viewing...

Question 19

A section that appears by itself at the top of a page and the detail lines for the section appear on the previous page.

Accepted Answer

A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header 
A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header

Question 20

A formatted output (screen display or printout)of the contents of one or more tables in a database.

Accepted Answer

A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header 
A) Zoom 
B) Group Footer 
C) summary report 
D) report 
E) group band field
F)orphaned footer section
G)detail report
H)orphaned header section
I)Zoom slider
J)Group Header

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.

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

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.

A field used to group the detail items in a report.

Values in a selected column may be summarized using any of eight ____________________ functions on the Totals menu from the DESIGN tab.

Design view should be used to modify a report when the user wants to add lines,rectangles,and other controls only available in Design view.____________________

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.

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

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

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

The section of a report that usually displays subtotals or counts for records in a group.

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

A section that appears by itself at the bottom of a page.

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.

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

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

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

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

A section that appears by itself at the top of a page and the detail lines for the section appear on the previous page.

A formatted output (screen display or printout)of the contents of one or more tables in a database.

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 Formsmodule

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

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.

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

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.

A field used to group the detail items in a report.

Values in a selected column may be summarized using any of eight ____________________ functions on the Totals menu from the DESIGN tab.

Design view should be used to modify a report when the user wants to add lines,rectangles,and other controls only available in Design view.____________________

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.

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

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

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

The section of a report that usually displays subtotals or counts for records in a group.

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

A section that appears by itself at the bottom of a page.

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.

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

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

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

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

A section that appears by itself at the top of a page and the detail lines for the section appear on the previous page.

A formatted output (screen display or printout)of the contents of one or more tables in a database.

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 Formsmodule

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