Question 1

Which of the following is NOT a common report embellishment?

Accepted Answer

A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons 
A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons

Question 2

The Group Footer section prints ____.

Accepted Answer

A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page 
A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

Koch labels are the most common manufacturer of labels, and therefore the default choice. _________________________

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

In Report Design View, click the Label b

Question 8

The Report Footer section prints ____.

Accepted Answer

A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page 
A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page

Question 9

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 10

In Report Design View, you can use commands on the Align button of the _____ tab.

Accepted Answer

A)  Arrange 
B)  Design 
C)  Format 
D)  Home 
A)  Arrange 
B)  Design 
C)  Format 
D)  Home

Question 11

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 12

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

Accepted Answer

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

Question 13

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

____________________ orientation is 8.5" wide by 11" tall.

Accepted Answer

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

Question 16

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 17

You can rename labels in Report Layout View.

Accepted Answer

A) True 
 B)False

Question 18

____________________ orientation is 11" wide by 8.5" tall.

Accepted Answer

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

Question 19

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

Accepted Answer

A)  Report View 
B)  Print Preview 
C)  Layout View 
D)  Design View 
A)  Report View 
B)  Print Preview 
C)  Layout View 
D)  Design View

Question 20

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

Which of the following is NOT a common report embellishment?

The Group Footer section prints ____.

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

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

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

Koch labels are the most common manufacturer of labels, and therefore the default choice. _________________________

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

The Report Footer section prints ____.

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

In Report Design View, you can use commands on the Align button of the _____ tab.

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

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

The Group Header section prints ____.

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

____________________ orientation is 8.5" wide by 11" tall.

You can rename labels in Report Layout View.

____________________ orientation is 11" wide by 8.5" tall.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

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?

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

Which of the following is NOT a common report embellishment?

The Group Footer section prints ____.

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

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

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

Koch labels are the most common manufacturer of labels, and therefore the default choice. _________________________

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

The Report Footer section prints ____.

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

In Report Design View, you can use commands on the Align button of the _____ tab.

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

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

The Group Header section prints ____.

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

____________________ orientation is 8.5" wide by 11" tall.

You can rename labels in Report Layout View.

____________________ orientation is 11" wide by 8.5" tall.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

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?

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