Question 1

A filter may be applied to data when a report is viewed using the Layout view.____________________

Accepted Answer

A) True 
 B)False

Question 2

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 3

When the Title button on the Design tab is used to insert a title on a report,the title is added to the ___________________ section by default.

Accepted Answer

The answer of When the Title button on the Design...

Question 4

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

Question 5

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 6

A label controlmust be used when a report requires a specific date that is not the current date.____________________

Accepted Answer

A) True 
 B)False

Question 7

The control on the status bar used in report view to zoom in or out in 10% increments.

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Reports may only be viewed in Print Preview.

Accepted Answer

A) True 
 B)False

Question 10

The Keep Together property,which determines how group data will be printed,is set using the  ____________________.

Accepted Answer

The answer of The Keep Together property,which determines how group...

Question 11

Discuss four report design guidelines that should be followed when planning a report design.

Accepted Answer

1.Determine the purpose of the report an

Question 12

Which control format property adds comma separators and two decimal places in report Design view.

Accepted Answer

A) Standard 
B) Currency 
C) Fixed 
D) General Number 
A) Standard 
B) Currency 
C) Fixed 
D) General Number

Question 13

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

Use the ____________________ to quickly create labels based on uniquely identified label templates.

Accepted Answer

The answer of Use the ____________________ to quickly create labels...

Question 17

TheDetail Section of a report usually contains most of the report contents.____________________

Accepted Answer

A) True 
 B)False

Question 18

The text box property that allows the box to expand vertically to fit the field value is the ____ property.

Accepted Answer

A) Can Grow 
B) Width 
C) Can Shrink 
D) Bottom Margin 
A) Can Grow 
B) Width 
C) Can Shrink 
D) Bottom Margin

Question 19

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 20

A typical Group Footer section will include which type of data?

Accepted Answer

A) a count or subtotal for records in that group 
B) the date and time the report was generated 
C) the report page number 
D) detail fields for all records included in the group 
A) a count or subtotal for records in that group 
B) the date and time the report was generated 
C) the report page number 
D) detail fields for all records included in the group

A filter may be applied to data when a report is viewed using the Layout view.____________________

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

When the Title button on the Design tab is used to insert a title on a report,the title is added to the ___________________ section by default.

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

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

A label controlmust be used when a report requires a specific date that is not the current date.____________________

The control on the status bar used in report view to zoom in or out in 10% increments.

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

Reports may only be viewed in Print Preview.

The Keep Together property,which determines how group data will be printed,is set using the ____________________.

Discuss four report design guidelines that should be followed when planning a report design.

Which control format property adds comma separators and two decimal places in report Design view.

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

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

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

Use the ____________________ to quickly create labels based on uniquely identified label templates.

TheDetail Section of a report usually contains most of the report contents.____________________

The text box property that allows the box to expand vertically to fit the field value is the ____ property.

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

A typical Group Footer section will include which type of data?

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 filter may be applied to data when a report is viewed using the Layout view.____________________

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

When the Title button on the Design tab is used to insert a title on a report,the title is added to the ___________________ section by default.

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

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

A label controlmust be used when a report requires a specific date that is not the current date.____________________

The control on the status bar used in report view to zoom in or out in 10% increments.

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

Reports may only be viewed in Print Preview.

The Keep Together property,which determines how group data will be printed,is set using the ____________________.

Discuss four report design guidelines that should be followed when planning a report design.

Which control format property adds comma separators and two decimal places in report Design view.

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

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

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

Use the ____________________ to quickly create labels based on uniquely identified label templates.

TheDetail Section of a report usually contains most of the report contents.____________________

The text box property that allows the box to expand vertically to fit the field value is the ____ property.

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

A typical Group Footer section will include which type of data?

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

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