Question 1

Page numbers must be added to a report in Design view.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: The control on the status bar used in report view to zoom in or out in 10% increments.

Accepted Answer

The Answer of Zoom slider and group band field and is...

Question 7

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 8

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 9

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 10

Match between columns
                        Premises: The section of a report that usually displays the group name and the sort field value for the group.

Accepted Answer

The Answer of Zoom and group band field and Zoom is...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

Use the Visible property in a report to hide a control when the control's value is the same as the value of the preceding record in the group. ____________________

Accepted Answer

A) True 
 B)False

Question 15

When you copy information contained  in an Access object such as a report, it is placed on the __________.

Accepted Answer

The answer of When you copy information contained  in an...

Question 16

Match between columns
                        Premises: A formatted output (screen display or printout)of the contents of one or more tables in a database.

Accepted Answer

The Answer of Group Header and summary report and Zoom is...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view.

Accepted Answer

A) Page Header section 
B) Group Header section 
C) Report Header Section 
D) Detail section 
A) Page Header section 
B) Group Header section 
C) Report Header Section 
D) Detail section

Question 20

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

Accepted Answer

A) True 
 B)False

Page numbers must be added to a report in Design view.

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

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

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

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

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

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

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

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

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

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

Use the Visible property in a report to hide a control when the control's value is the same as the value of the preceding record in the group. ____________________

When you copy information contained in an Access object such as a report, it is placed on the __________.

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

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

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view.

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

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

Page numbers must be added to a report in Design view.

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

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

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

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

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

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

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

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

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

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

Use the Visible property in a report to hide a control when the control's value is the same as the value of the preceding record in the group. ____________________

When you copy information contained in an Access object such as a report, it is placed on the __________.

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

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

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view.

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

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