Question 1

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The type of report that displays summary information,such as grand totals and/or subtotals,using fields from a record source.

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 4

Which section contains content that will appear at the top of every page of a report?

Accepted Answer

A) Group Header 
B) Report Header 
C) Page Header 
D) Document Header 
A) Group Header 
B) Report Header 
C) Page Header 
D) Document Header

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

The section of a report that usually displays the group name and the sort field value for the 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 7

A report sort field that includes a Group Header section and a Group Footer section is a grouping field.____________________

Accepted Answer

A) True 
 B)False

Question 8

Placing the report title,date,and page number on the same line in the ____ is a common report standard.

Accepted Answer

A) Report Header 
B) Page Header 
C) Report Footer 
D) Page Footer 
A) Report Header 
B) Page Header 
C) Report Footer 
D) Page Footer

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

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 11

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 12

Which report view is the best to use to see what a report will look like when it is printed?

Accepted Answer

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

Question 13

In the expression =Date(),used to return the current date,which portion of the expression is the name of the function?

Accepted Answer

A) = 
B) Date() 
C) Date 
D) =Date 
A) = 
B) Date() 
C) Date 
D) =Date

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

Access allows the creation of mailing labels based on manufacturer templates or custom formatted labels.

Accepted Answer

A) True 
 B)False

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.

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

The type of report that displays summary information,such as grand totals and/or subtotals,using fields from a record source.

Which section contains content that will appear at the top of every page of a report?

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

The section of a report that usually displays the group name and the sort field value for the group.

A report sort field that includes a Group Header section and a Group Footer section is a grouping field.____________________

Placing the report title,date,and page number on the same line in the ____ is a common report standard.

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

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

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

Which report view is the best to use to see what a report will look like when it is printed?

In the expression =Date(),used to return the current date,which portion of the expression is the name of the function?

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

Access allows the creation of mailing labels based on manufacturer templates or custom formatted labels.

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

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.

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

The type of report that displays summary information,such as grand totals and/or subtotals,using fields from a record source.

Which section contains content that will appear at the top of every page of a report?

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

The section of a report that usually displays the group name and the sort field value for the group.

A report sort field that includes a Group Header section and a Group Footer section is a grouping field.____________________

Placing the report title,date,and page number on the same line in the ____ is a common report standard.

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

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

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

Which report view is the best to use to see what a report will look like when it is printed?

In the expression =Date(),used to return the current date,which portion of the expression is the name of the function?

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

Access allows the creation of mailing labels based on manufacturer templates or custom formatted labels.

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