Question 1

The value of the Record Source property may  not be a query.

Accepted Answer

A) True 
 B)False

Question 2

Arguments are the pieces of information that a functio n needs to create a final answer.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

One way to select more than one control at a time in Report Design View is to click a control and press and hold ____ while clicking other controls.

Accepted Answer

A)  [Shift] 
B)  [Esc] 
C)  [F5] 
D)  [Alt] 
A)  [Shift] 
B)  [Esc] 
C)  [F5] 
D)  [Alt]

Question 5

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 is just getting started with one of the reports and he needs to quickly review it to see what it contains. He does not want his view to contain any page breaks. Which view 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 6

A ____ box is an outline box you create by dragging the pointer in Report Design View.

Accepted Answer

A)  selection 
B)  design 
C)  pointer 
D)  drag 
A)  selection 
B)  design 
C)  pointer 
D)  drag

Question 7

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 8

The Report Wizard automatically applies many formatting embellishments to a report.

Accepted Answer

A) True 
 B)False

Question 9

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 10

The Report Header section prints ____.

Accepted Answer

A)  at the top of every page 
B)  at the top of the first page 
C)  before every group of records 
D)  once for every record 
A)  at the top of every page 
B)  at the top of the first page 
C)  before every group of records 
D)  once for every record

Question 11

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The quick keystroke for Undo is _____.

Accepted Answer

A)  [Ctrl][W] 
B)  [Ctrl][Y] 
C)  [Ctrl][X] 
D)  [Ctrl][Z] 
A)  [Ctrl][W] 
B)  [Ctrl][Y] 
C)  [Ctrl][X] 
D)  [Ctrl][Z]

Question 14

The Mailing Wizard is a special report wizard that precisely positions and sizes information for hundreds of standard business labels. _________________________

Accepted Answer

A) True 
 B)False

Question 15

The quick keystroke for Redo is [Ctrl][Z]. _________________________

Accepted Answer

A) True 
 B)False

Question 16

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.

Accepted Answer

A)  launcher 
B)  section header 
C)  ruler 
D)  command line 
A)  launcher 
B)  section header 
C)  ruler 
D)  command line

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Portrait orientation is 8.5" wide by 13" tall.

Accepted Answer

A) True 
 B)False

Question 19

To reverse an action in Layout view, use the ____________________ button.

Accepted Answer

The answer of To reverse an action in Layout view,...

Question 20

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.
Which of the following will Bradley use if he is looking for the optimal view for changing the positioning of some of his report controls while also reviewing the live data?

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

The value of the Record Source property may not be a query.

Arguments are the pieces of information that a functio n needs to create a final answer.

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

One way to select more than one control at a time in Report Design View is to click a control and press and hold ____ while clicking other controls.

A ____ box is an outline box you create by dragging the pointer in Report Design View.

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

The Report Wizard automatically applies many formatting embellishments to a report.

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

The Report Header section prints ____.

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

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

The quick keystroke for Undo is _____.

The Mailing Wizard is a special report wizard that precisely positions and sizes information for hundreds of standard business labels. _________________________

The quick keystroke for Redo is [Ctrl][Z]. _________________________

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.

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

Portrait orientation is 8.5" wide by 13" tall.

To reverse an action in Layout view, use the ____________________ button.

Getting Started With Access

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 4: Using Reports

The value of the Record Source property may not be a query.

Arguments are the pieces of information that a functio n needs to create a final answer.

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

One way to select more than one control at a time in Report Design View is to click a control and press and hold ____ while clicking other controls.

A ____ box is an outline box you create by dragging the pointer in Report Design View.

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

The Report Wizard automatically applies many formatting embellishments to a report.

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

The Report Header section prints ____.

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

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

The quick keystroke for Undo is _____.

The Mailing Wizard is a special report wizard that precisely positions and sizes information for hundreds of standard business labels. _________________________

The quick keystroke for Redo is [Ctrl][Z]. _________________________

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.

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

Portrait orientation is 8.5" wide by 13" tall.

To reverse an action in Layout view, use the ____________________ button.

Getting Started With Access

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters