Question 1

Which section prints below the Report Header on page one?

Accepted Answer

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

Question 2

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 3

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 4

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities. What central feature of tables, queries, and forms is not shared by reports?

Accepted Answer

Reports are read-only objects, meaning y

Question 5

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 ready to print his report, but he only wants to print specific pages of the report. On what tab can he find the options to accomplish this task?

Accepted Answer

A)  Print Preview 
B) Print Options 
C)  Selection 
D)  Tools 
A)  Print Preview 
B) Print Options 
C)  Selection 
D)  Tools

Question 6

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 7

Portrait orientation is 8.5" wide by 13" tall.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

The Page Footer section prints ____.

Accepted Answer

A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records 
A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records

Question 12

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 13

In Report Layout View, you can work with sections and make modifications that you cannot make in other views.​

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is NOT a common report embellishment?

Accepted Answer

A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons 
A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons

Question 15

[Ctrl][Y] is the quick keystroke for the ____________________ command.

Accepted Answer

The answer of [Ctrl][Y] is the quick keystroke for the...

Question 16

In Report Design View, you can use commands on the Align button of the _____ tab.​

Accepted Answer

A)  ​Arrange 
B)  ​Design 
C)  ​Format 
D)  ​Home 
A)  ​Arrange 
B)  ​Design 
C)  ​Format 
D)  ​Home

Question 17

When using a wizard, you can click the Back button to review previous dialog boxes.

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

The Page Header section prints ____.

Accepted Answer

A)  at the top of the first page 
B)  at the top of every page (but below the Report Header on the first page) 
C)  before every group of records 
D)  after every group of records 
A)  at the top of the first page 
B)  at the top of every page (but below the Report Header on the first page) 
C)  before every group of records 
D)  after every group of records

Question 20

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Accepted Answer

The answer of The ____________________ source is the table or...

Which section prints below the Report Header on page one?

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

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

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities. What central feature of tables, queries, and forms is not shared by reports?

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

Portrait orientation is 8.5" wide by 13" tall.

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

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

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 Page Footer section prints ____.

The quick keystroke for Undo is _____.

In Report Layout View, you can work with sections and make modifications that you cannot make in other views.

Which of the following is NOT a common report embellishment?

[Ctrl][Y] is the quick keystroke for the ____________________ command.

In Report Design View, you can use commands on the Align button of the _____ tab.

When using a wizard, you can click the Back button to review previous dialog boxes.

The Page Header section prints ____.

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Getting Started With Office 2017

Building and Using Queries

Using Forms

Module 1 Getting Started With Access

Filters

Exam 4: Using Reports

Which section prints below the Report Header on page one?

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

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

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities. What central feature of tables, queries, and forms is not shared by reports?

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

Portrait orientation is 8.5" wide by 13" tall.

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

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

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 Page Footer section prints ____.

The quick keystroke for Undo is _____.​

In Report Layout View, you can work with sections and make modifications that you cannot make in other views.​

Which of the following is NOT a common report embellishment?

[Ctrl][Y] is the quick keystroke for the ____________________ command.

In Report Design View, you can use commands on the Align button of the _____ tab.​

When using a wizard, you can click the Back button to review previous dialog boxes.

The Page Header section prints ____.

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Getting Started With Office 2017

Building and Using Queries

Using Forms

Module 1 Getting Started With Access

Filters

The quick keystroke for Undo is _____.

In Report Layout View, you can work with sections and make modifications that you cannot make in other views.

In Report Design View, you can use commands on the Align button of the _____ tab.