Question 1

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 2

In the figure above, what button is identified as item 3?

Accepted Answer

A)  Underline 
B)  Align Text Left 
C)  Align Text Right 
D)  Align Text Under 
A)  Underline 
B)  Align Text Left 
C)  Align Text Right 
D)  Align Text Under

Question 3

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 page one) 
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 page one) 
C)  Before every group of records 
D)  After every group of records

Question 4

Which control is most commonly placed in the Report Header section?

Accepted Answer

A)  Text box 
B)  Subtotal 
C)  Check box 
D)  Label 
A)  Text box 
B)  Subtotal 
C)  Check box 
D)  Label

Question 5

Marshall plans to generate reports from an Access table using the Report Wizard.The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice.What expression would Marshall use to calculate a grand total of the PurchasePrice field in the Report Footer?

Accepted Answer

=Sum([Purc

Question 6

Which control is most commonly placed in the Detail section of a report?

Accepted Answer

A)  Label 
B)  Subtotal 
C)  Text box 
D)  Command button 
A)  Label 
B)  Subtotal 
C)  Text box 
D)  Command button

Question 7

Use the alignment buttons on the Design tab to align the edges of the controls with respect to one another.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

The Group Header section prints ____.

Accepted Answer

A)  At the top of the first page of the report 
B)  At the top of every page 
C)  Once for every record 
D)  Before every group of records 
A)  At the top of the first page of the report 
B)  At the top of every page 
C)  Once for every record 
D)  Before every group of records

Question 10

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

Accepted Answer

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

Question 11

____________________ orientation is 11" wide by 8.5" tall.

Accepted Answer

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

Question 12

How does grouping compare to sorting?

Accepted Answer

Grouping not only sorts record

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

Marshall plans to generate reports from an Access table using the Report Wizard.The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice.What feature of Report Design View would Marshall use to change sorting and grouping orders?

Accepted Answer

Group, Sor

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

In the figure above, what button is identified as item 2?

Accepted Answer

A)  Italic 
B)  Bold 
C)  Underline 
D)  Center 
A)  Italic 
B)  Bold 
C)  Underline 
D)  Center

Question 19

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

Question 20

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

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

In the figure above, what button is identified as item 3?

The Page Header section prints ____.

Which control is most commonly placed in the Report Header section?

Which control is most commonly placed in the Detail section of a report?

Use the alignment buttons on the Design tab to align the edges of the controls with respect to one another.

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

The Group Header section prints ____.

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

____________________ orientation is 11" wide by 8.5" tall.

How does grouping compare to sorting?

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?

The Page Footer section prints ____.

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

In the figure above, what button is identified as item 2?

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

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

Getting Started With Access 2.0

Building and Using Queries

Using Forms

Getting Started With Microsoft

Web Apps: Working With Windows Live and Office Web Apps

Filters

Exam 4: Using Reports Question

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

In the figure above, what button is identified as item 3?

The Page Header section prints ____.

Which control is most commonly placed in the Report Header section?

Which control is most commonly placed in the Detail section of a report?

Use the alignment buttons on the Design tab to align the edges of the controls with respect to one another.

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

The Group Header section prints ____.

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

____________________ orientation is 11" wide by 8.5" tall.

How does grouping compare to sorting?

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?

The Page Footer section prints ____.

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

In the figure above, what button is identified as item 2?

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

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

Getting Started With Access 2.0

Building and Using Queries

Using Forms

Getting Started With Microsoft

Web Apps: Working With Windows Live and Office Web Apps

Filters