Question 1

Access reports can be created by selecting fields from one or more tables or queries.

Accepted Answer

A) True 
 B)False  True

Question 2

Grouping means to sort records plus provide extra report sections.

Accepted Answer

A) True 
 B)False  True

Question 3

The purpose of a report is to provide an easy-to-use data entry interface.

Accepted Answer

A) True 
 B)False  False

Question 4

The report section before a group of records is called the Group ____________________ section.

Accepted Answer

The answer of The report section before a group of...

Question 5

Reports are changeable objects, meaning you can use them to change data.

Accepted Answer

A) True 
 B)False

Question 6

Report Design View displays both a horizontal and a vertical ruler.

Accepted Answer

A) True 
 B)False

Question 7

You can apply more than one grouping order to a report.

Accepted Answer

A) True 
 B)False

Question 8

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 9

In the expression =Sum([Price]), the ____________________ function is used.

Accepted Answer

The answer of In the expression =Sum([Price]), the ____________________ function...

Question 10

To view a report to determine whether to change orientation from portrait to landscape, right-click the report in the Navigation Pane and click _____ on the shortcut menu.

Accepted Answer

A)  Orientation 
B)  Preview Report 
C)  Print Preview 
D)  Preview Orientation 
A)  Orientation 
B)  Preview Report 
C)  Print Preview 
D)  Preview Orientation

Question 11

Use the Align button on the Design tab to align the edges of the controls with respect to one another. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

Accepted Answer

A)  Click a control, then [Shift]+click other controls 
B)  Dragging a selection box 
C)  Clicking in the ruler 
D)  Right-dragging 
A)  Click a control, then [Shift]+click other controls 
B)  Dragging a selection box 
C)  Clicking in the ruler 
D)  Right-dragging

Question 13

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}

Question 14

Which command can you use to move a control from one section to another on a report?

Accepted Answer

A)  Move 
B)  Place 
C)  Adjust 
D)  Cut 
A)  Move 
B)  Place 
C)  Adjust 
D)  Cut

Question 15

Which two sections can be added to a report if you group records?

Accepted Answer

A)  Group Header and Group Footer 
B)  Group Header and Detail 
C)  Group Footer and Detail 
D)  Group Summary and Detail 
A)  Group Header and Group Footer 
B)  Group Header and Detail 
C)  Group Footer and Detail 
D)  Group Summary and Detail

Question 16

In Report Design View, you can click in the ____________________ to select all controls that intersect the selection line.

Accepted Answer

The answer of In Report Design View, you can click...

Question 17

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 18

To quickly review a report without page breaks use ____________________ View.

Accepted Answer

The answer of To quickly review a report without page...

Question 19

Calculated expressions start with an equal sign.

Accepted Answer

A) True 
 B)False

Question 20

Which command is used to copy a control from one report section to another?

Accepted Answer

A)  Move 
B)  Second 
C)  Duplicate 
D)  Copy 
A)  Move 
B)  Second 
C)  Duplicate 
D)  Copy

Access reports can be created by selecting fields from one or more tables or queries.

Grouping means to sort records plus provide extra report sections.

The purpose of a report is to provide an easy-to-use data entry interface.

The report section before a group of records is called the Group ____________________ section.

Reports are changeable objects, meaning you can use them to change data.

Report Design View displays both a horizontal and a vertical ruler.

You can apply more than one grouping order to a report.

Which section prints once for every record?

In the expression =Sum([Price]), the ____________________ function is used.

To view a report to determine whether to change orientation from portrait to landscape, right-click the report in the Navigation Pane and click _____ on the shortcut menu.

Use the Align button on the Design tab to align the edges of the controls with respect to one another. _________________________

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

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

Which command can you use to move a control from one section to another on a report?

Which two sections can be added to a report if you group records?

In Report Design View, you can click in the ____________________ to select all controls that intersect the selection line.

The Page Header section prints ____.

To quickly review a report without page breaks use ____________________ View.

Calculated expressions start with an equal sign.

Which command is used to copy a control from one report section to another?

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

Access reports can be created by selecting fields from one or more tables or queries.

Grouping means to sort records plus provide extra report sections.

The purpose of a report is to provide an easy-to-use data entry interface.

The report section before a group of records is called the Group ____________________ section.

Reports are changeable objects, meaning you can use them to change data.

Report Design View displays both a horizontal and a vertical ruler.

You can apply more than one grouping order to a report.

Which section prints once for every record?

In the expression =Sum([Price]), the ____________________ function is used.

To view a report to determine whether to change orientation from portrait to landscape, right-click the report in the Navigation Pane and click _____ on the shortcut menu.

Use the Align button on the Design tab to align the edges of the controls with respect to one another. _________________________

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

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

Which command can you use to move a control from one section to another on a report?

Which two sections can be added to a report if you group records?

In Report Design View, you can click in the ____________________ to select all controls that intersect the selection line.

The Page Header section prints ____.

To quickly review a report without page breaks use ____________________ View.

Calculated expressions start with an equal sign.

Which command is used to copy a control from one report section to another?

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