Question 1

By selecting a product number in the Label Wizard, you also specify the dimensions of the label and the number of columns.

Accepted Answer

A) True 
 B)False

Question 2

Discuss the meanings of calculation, expression, function, and argument.

Accepted Answer

You create a calculation by entering an

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 almost ready to print one of the reports. He wants to review the first page of the report to see how it will look when printed. Which view should he use?

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 5

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 6

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 7

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 wants to focus on just the details of one of the reports, without seeing the data. Which of the following should he use?

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 8

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 9

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 10

The control source is the table or query that defines the fields and records displayed in the report.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

____ refers to enhancing the appearance of the information.

Accepted Answer

A)  Laying out 
B)  Coloring 
C)  Formatting 
D)  Reshaping 
A)  Laying out 
B)  Coloring 
C)  Formatting 
D)  Reshaping

Question 13

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 14

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

Accepted Answer

A)  ruler 
B)  section header 
C)  launcher 
D)  command line 
A)  ruler 
B)  section header 
C)  launcher 
D)  command line

Question 15

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

By selecting a product number in the Label Wizard, you also specify the dimensions of the label and the number of columns.

Discuss the meanings of calculation, expression, function, and argument.

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

Which section prints below the Report Header on page one?

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

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

The Page Footer section prints ____.

The control source is the table or query that defines the fields and records displayed in the report.

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

____ refers to enhancing the appearance of the information.

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

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

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

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

By selecting a product number in the Label Wizard, you also specify the dimensions of the label and the number of columns.

Discuss the meanings of calculation, expression, function, and argument.

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

Which section prints below the Report Header on page one?

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

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

The Page Footer section prints ____.

The control source is the table or query that defines the fields and records displayed in the report.

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

____ refers to enhancing the appearance of the information.

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

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

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

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