Question 1

The tasks that can be accomplished by each of the various report views are mutually exclusive.

Accepted Answer

A) True 
 B)False

Question 2

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow. _________________________

Accepted Answer

A) True 
 B)False

Question 3

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

Accepted Answer

A) True 
 B)False

Question 4

The same expression in different sections of a report produces different calculations.

Accepted Answer

A) True 
 B)False

Question 5

The Report Footer section prints ____.

Accepted Answer

A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page 
A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page

Question 6

Critical Thinking Questions Case 4-1
Bradley plans to generate reports from an Access database that a colleague of his built. As he works with the reports, he decides to familiarize himself with each of the views that is available to him.
Bradley wants to focus on just the details of one of the reports, without seeing the data. Which of the following should he use?

Accepted Answer

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

Question 7

Use the Align button on the DESIGN tab to align the edges of the controls with respect to one another. _________________________

Accepted Answer

A) True 
 B)False

Question 8

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

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 9

A(n) ____________________ is a built-in formula, such as Sum or Count.

Accepted Answer

The answer of A(n) ____________________ is a built-in formula, such...

Question 10

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

Accepted Answer

A) True 
 B)False

Question 11

____________________ orientation is 11" wide by 8.5" tall.

Accepted Answer

The answer of ____________________ orientation is 11" wide by 8.5"...

Question 12

In the accompanying figure, item 2 points to a Group Footer section.

Accepted Answer

A) True 
 B)False

Question 13

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

Accepted Answer

A)  upper-right 
B)  lower-left 
C)  lower-right 
D)  upper-left 
A)  upper-right 
B)  lower-left 
C)  lower-right 
D)  upper-left

Question 14

In the accompanying figure, item 1 points to the ____ section.

Accepted Answer

A)  Group Header 
B)  Page Header 
C)  Detail 
D)  Page Footer 
A)  Group Header 
B)  Page Header 
C)  Detail 
D)  Page Footer

Question 15

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

Accepted Answer

The answer of Use the Group, Sort, and ____________________ pane...

Question 16

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

Accepted Answer

A)  =Sum(Quantity) 
B)  =Sum[Quantity] 
C)  =Sum{Quantity} 
D)  =Sum([Quantity]) 
A)  =Sum(Quantity) 
B)  =Sum[Quantity] 
C)  =Sum{Quantity} 
D)  =Sum([Quantity])

Question 17

Match between columns
                        Premises: Font Color
Center
Alternate Row Color
Align Right
Background Color or Shape Fill
Shape Outline
Align Left
Underline

Accepted Answer

The Answer of Item 2 and Item 8 and Item is...

Question 18

You can both group and sort records on the same report.

Accepted Answer

A) True 
 B)False

Question 19

You can apply more than one grouping order to a report.

Accepted Answer

A) True 
 B)False

Question 20

Which report view's primary purpose is to quickly review the report without page breaks?

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

The tasks that can be accomplished by each of the various report views are mutually exclusive.

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow. _________________________

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

The same expression in different sections of a report produces different calculations.

The Report Footer section prints ____.

Use the Align button on the DESIGN tab to align the edges of the controls with respect to one another. _________________________

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

A(n) ____________________ is a built-in formula, such as Sum or Count.

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

____________________ orientation is 11" wide by 8.5" tall.

In the accompanying figure, item 2 points to a Group Footer section.

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

In the accompanying figure, item 1 points to the ____ section.

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

You can both group and sort records on the same report.

You can apply more than one grouping order to a report.

Which report view's primary purpose is to quickly review the report without page breaks?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 4: Using Reports

The tasks that can be accomplished by each of the various report views are mutually exclusive.

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow. _________________________

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

The same expression in different sections of a report produces different calculations.

The Report Footer section prints ____.

Use the Align button on the DESIGN tab to align the edges of the controls with respect to one another. _________________________

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

A(n) ____________________ is a built-in formula, such as Sum or Count.

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

____________________ orientation is 11" wide by 8.5" tall.

In the accompanying figure, item 2 points to a Group Footer section.

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

In the accompanying figure, item 1 points to the ____ section.

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

You can both group and sort records on the same report.

You can apply more than one grouping order to a report.

Which report view's primary purpose is to quickly review the report without page breaks?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters