Question 1

Basing a report on a parameter query is useful if you need to run multiple reports that display unique information.

Accepted Answer

A) True 
 B)False  False

Question 2

Clicking Close Print Preview takes you into ____ view.

Accepted Answer

A)  Report 
B)  Design 
C)  Data 
D)  Layout 
A)  Report 
B)  Design 
C)  Data 
D)  Layout B

Question 3

FIGURE AC 10-17   In Figure AC 10-17 above, the box where an expression will be entered is referenced by ____.

Accepted Answer

A)  Item 1 
B)  Item 2 
C)  Item 3 
D)  Item 4 
A)  Item 1 
B)  Item 2 
C)  Item 3 
D)  Item 4 A

Question 4

The controls in a report have multiple ____ that can be changed once they are added to the report.

Accepted Answer

A)  styles 
B)  themes 
C)  functions 
D)  properties 
A)  styles 
B)  themes 
C)  functions 
D)  properties

Question 5

Describe when to use a summary report and briefly describe the possible functions. Include a discussion on how to create a summary report.

Accepted Answer

If you know ahead of time that you want

Question 6

Case AC 10-1 John is working on the annual sales report for the Rain Flower Media Corporation. After adding the currency format to the total sales field, John runs the report and directs the results to his monitor. To his dismay, the total sales column displays pound signs (#) instead of his sales total figures. The report is due tomorrow and he desperately needs your assistance. What would you recommend John do to correct the problem with the pound signs(#) displaying?

Accepted Answer

A)  Increase the width of the Sales text box. 
B)  Correct his calculating formula. 
C)  Use a wide-screen monitor. 
D)  Send the report to a printer. 
A)  Increase the width of the Sales text box. 
B)  Correct his calculating formula. 
C)  Use a wide-screen monitor. 
D)  Send the report to a printer.

Question 7

A(n) ____________________ displays a message box for you to enter parameter data each time you run the query.

Accepted Answer

The answer of A(n) ____________________ displays a message box for...

Question 8

You access the Report Wizard by clicking the Create tab on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 9

A control text box displays the actual data from the table.

Accepted Answer

A) True 
 B)False

Question 10

When you select controls in a report, you ____ to select the control.

Accepted Answer

A)  click 
B)  double-click 
C)  right-click 
D)  triple-click 
A)  click 
B)  double-click 
C)  right-click 
D)  triple-click

Question 11

____________________ let you add borders, background colors, shading, and graphic effects to an entire report at one time.

Accepted Answer

The answer of ____________________ let you add borders, background colors,...

Question 12

Case AC 10-2 Stella Maroon owns the Stellar boutique in Malibu. Every month she must reconcile her inventory and take note of customer purchasing trends. One of her Paris suppliers is insisting that a blue cashmere shawl is going to be the latest trend over the next three months. Stella has some doubts, and would like to see some additional boutique sales reports to see if her clients are indeed trending towards shawls. She asks if you could assist her in creating these reports. What is a valid option selection for Stella's new report?

Accepted Answer

A)  Stella can only select the Avg function. 
B)  The Min and Max functions cannot be selected simultaneously. 
C)  Stella can select the Avg, Sum, Min and Max functions simultaneously. 
D)  If Stella selects the Avg function, she must also select the Sum function. 
A)  Stella can only select the Avg function. 
B)  The Min and Max functions cannot be selected simultaneously. 
C)  Stella can select the Avg, Sum, Min and Max functions simultaneously. 
D)  If Stella selects the Avg function, she must also select the Sum function.

Question 13

To view more of a report, click the Close Shutter Bar button on the Navigation pane.

Accepted Answer

A) True 
 B)False

Question 14

Access can only create pie charts.

Accepted Answer

A) True 
 B)False

Question 15

____________________ formatting allows you to add formatting features to the data based on criteria you specify.

Accepted Answer

The answer of ____________________ formatting allows you to add formatting...

Question 16

Match between columns
                        Premises: Graphical display of data.
Describes what is in the field.
Uses functions to see trends in data.
Displays the actual data from the table.
Places the dollar sign and commas in the control.

Accepted Answer

The Answer of chart and summary report and currency format is...

Question 17

By adding a calculated control in the report ____, the total of the sales will be displayed at the end of the report.

Accepted Answer

A)  base 
B)  footer 
C)  record 
D)  expression builder form 
A)  base 
B)  footer 
C)  record 
D)  expression builder form

Question 18

To reopen the Navigation pane, you can click the ____ button.

Accepted Answer

A)  Reopen 
B)  Open 
C)  Open Shutter Bar 
D)  Reopen Shutter Bar 
A)  Reopen 
B)  Open 
C)  Open Shutter Bar 
D)  Reopen Shutter Bar

Question 19

When using a report based on a parameter query, you need to create several reports.

Accepted Answer

A) True 
 B)False

Question 20

To move a control in Design view, you can select the control, press and hold the ____ key, and then press the arrow keys to move the control right, left, up, or down.

Accepted Answer

A)  CTRL 
B)  TAB 
C)  SHIFT 
D)  ALT 
A)  CTRL 
B)  TAB 
C)  SHIFT 
D)  ALT

Exam 10: Adding Advanced Features to Reports

Basing a report on a parameter query is useful if you need to run multiple reports that display unique information.

Clicking Close Print Preview takes you into ____ view.

FIGURE AC 10-17 In Figure AC 10-17 above, the box where an expression will be entered is referenced by ____.

The controls in a report have multiple ____ that can be changed once they are added to the report.

Describe when to use a summary report and briefly describe the possible functions. Include a discussion on how to create a summary report.

A(n) ____________________ displays a message box for you to enter parameter data each time you run the query.

You access the Report Wizard by clicking the Create tab on the Ribbon.

A control text box displays the actual data from the table.

When you select controls in a report, you ____ to select the control.

____________________ let you add borders, background colors, shading, and graphic effects to an entire report at one time.

To view more of a report, click the Close Shutter Bar button on the Navigation pane.

Access can only create pie charts.

____________________ formatting allows you to add formatting features to the data based on criteria you specify.

By adding a calculated control in the report ____, the total of the sales will be displayed at the end of the report.

To reopen the Navigation pane, you can click the ____ button.

When using a report based on a parameter query, you need to create several reports.

To move a control in Design view, you can select the control, press and hold the ____ key, and then press the arrow keys to move the control right, left, up, or down.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters