Question 1

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 D

Question 2

Which section prints once for every record?

Accepted Answer

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

Question 3

Which of the following is the correct expression to count the number of records using a field named City?

Accepted Answer

A)  =Count([City]) 
B)  =Count[City] 
C)  =Count(City) 
D)  =Count{City} 
A)  =Count([City]) 
B)  =Count[City] 
C)  =Count(City) 
D)  =Count{City} A

Question 4

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

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

Use the alignment buttons on the ____________________ tab to align the content of a control within its own border.

Accepted Answer

The answer of Use the alignment buttons on the ____________________...

Question 11

Adding a new text box automatically adds a new ____________________ to its left.​

Accepted Answer

The answer of Adding a new text box automatically adds...

Question 12

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 13

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 14

____________________ orientation is 8.5" wide by 11" tall.

Accepted Answer

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

Question 15

What are the steps to add a label to a report?

Accepted Answer

In Report Design View, click the Label b

Question 16

____________________ orientation is 11" wide by 8.5" tall.

Accepted Answer

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

Question 17

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

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 4: Access 4: Using Reports

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

Which section prints once for every record?

Which of the following is the correct expression to count the number of records using a field named City?

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

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

The quick keystroke for Undo is _____.​

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

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

Use the alignment buttons on the ____________________ tab to align the content of a control within its own border.

Adding a new text box automatically adds a new ____________________ to its left.​

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?

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

____________________ orientation is 8.5" wide by 11" tall.

What are the steps to add a label to a report?

____________________ orientation is 11" wide by 8.5" tall.

The Report Header section prints ____.

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

Which section prints below the Report Header on page one?

Access 1: Getting Started With Access

Access 2: Building and Using Queries

Access 3: Using Forms

Essential: Understanding Essential Computer Concepts

Excel 1: Getting Started With Excel 2016

Excel 2: Working With Formulas and Functions

Excel 3: Formatting a Worksheet

Excel 4: Working With Charts

Integration 1: Integrating Word and Excel

Integration 2: Integrating Word Excel and Access

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters

The quick keystroke for Undo is _____.

Adding a new text box automatically adds a new ____________________ to its left.