Question 1

Match each numbered item in the accompanying figure with its button name.
-Shape Outline

Accepted Answer

A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8 
A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8 H

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Match each numbered item in the accompanying figure with its button name.
-Center

Accepted Answer

A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8 
A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8 C

Question 4

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 5

Match each numbered item in the accompanying figure with its button name.
-Background Color or Shape Fill

Accepted Answer

A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8 
A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8

Question 6

-In the accompanying figure, item 5 points to the ____.

Accepted Answer

A)  Page number 
B)  Next Page button 
C)  Previous Page button 
D)  Last Page button 
A)  Page number 
B)  Next Page button 
C)  Previous Page button 
D)  Last Page button

Question 7

Calculated expressions start with an equal sign.

Accepted Answer

A) True 
 B)False

Question 8

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.
-Which of the following will Bradley use if he is looking for the optimal view for changing the positioning of some of his report controls while also reviewing the live data?

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 9

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

Accepted Answer

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

Question 10

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

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

Portrait orientation is 8.5" wide by 13" tall.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

Match each numbered item in the accompanying figure with its button name.
-Font Color

Accepted Answer

A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8 
A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

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

Question 19

The tasks that can be accomplished by each of the various report views are mutually exclusive.

Accepted Answer

A) True 
 B)False

Question 20

-In the accompanying figure, item 3 points to the ____ section.

Accepted Answer

A)  Page Footer 
B)  Report Footer 
C)  Group Footer 
D)  Report Header 
A)  Page Footer 
B)  Report Footer 
C)  Group Footer 
D)  Report Header

Match each numbered item in the accompanying figure with its button name. -Shape Outline

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

Match each numbered item in the accompanying figure with its button name. -Center

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

Match each numbered item in the accompanying figure with its button name. -Background Color or Shape Fill

-In the accompanying figure, item 5 points to the ____.

Calculated expressions start with an equal sign.

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

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?

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

Portrait orientation is 8.5" wide by 13" tall.

Which section prints below the Report Header on page one?

Match each numbered item in the accompanying figure with its button name. -Font Color

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

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

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

The tasks that can be accomplished by each of the various report views are mutually exclusive.

-In the accompanying figure, item 3 points to the ____ section.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 5: Using Reports

Match each numbered item in the accompanying figure with its button name. -Shape Outline

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

Match each numbered item in the accompanying figure with its button name. -Center

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

Match each numbered item in the accompanying figure with its button name. -Background Color or Shape Fill

-In the accompanying figure, item 5 points to the ____.

Calculated expressions start with an equal sign.

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

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?

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

Portrait orientation is 8.5" wide by 13" tall.

Which section prints below the Report Header on page one?

Match each numbered item in the accompanying figure with its button name. -Font Color

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

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

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

The tasks that can be accomplished by each of the various report views are mutually exclusive.

-In the accompanying figure, item 3 points to the ____ section.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters