Question 1

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

Accepted Answer

A) True 
 B)False

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

Question 3

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 4

You can add a field as a grouping field in which pane?

Accepted Answer

A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total 
A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total

Question 5

In the accompanying figure, item 4 points to the ____ View button.

Accepted Answer

A)  Report 
B)  Layout 
C)  Zoom 
D)  Design 
A)  Report 
B)  Layout 
C)  Zoom 
D)  Design

Question 6

Grouping means to sort records plus provide extra report sections.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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])

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

Which section prints once for every record?

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.

You can add a field as a grouping field in which pane?

In the accompanying figure, item 4 points to the ____ View button.

Grouping means to sort records plus provide extra report sections.

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

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 4: Using Forms

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

Which section prints once for every record?

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.

You can add a field as a grouping field in which pane?

In the accompanying figure, item 4 points to the ____ View button.

Grouping means to sort records plus provide extra report sections.

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

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters