Question 1

To select several controls, you press and hold ____________________ and then click on each control you want to select.

Accepted Answer

The answer of To select several controls, you press and...

Question 2

When a report selector is selected, it appears with a dark ____.

Accepted Answer

A)  arrow 
B)  circle 
C)  triangle 
D)  square 
A)  arrow 
B)  circle 
C)  triangle 
D)  square

Question 3

By adding basic formatting to a report before you apply a(n) schema , the theme formats are enhanced.

Accepted Answer

A) True 
 B)False

Question 4

Click the Design tab, and then click the Themes button ____ in the Themes group to display the Themes gallery.

Accepted Answer

A)  check box 
B)  arrow 
C)  square 
D)  icon 
A)  check box 
B)  arrow 
C)  square 
D)  icon

Question 5

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 type of report would you suggest Stella run against her data to see trends in customer purchases?

Accepted Answer

A)  control report 
B)  parameter report 
C)  trend report 
D)  summary report 
A)  control report 
B)  parameter report 
C)  trend report 
D)  summary report

Question 6

When you change control formats, you will typically be changing the text box when the ____ is displayed.

Accepted Answer

A)  record 
B)  field 
C)  data 
D)  property 
A)  record 
B)  field 
C)  data 
D)  property

Question 7

When a report is based on a parameter query, each time you open the report, the ____ box appears.

Accepted Answer

A)  control 
B)  combo 
C)  text 
D)  message 
A)  control 
B)  combo 
C)  text 
D)  message

Question 8

To begin increasing a text box width in Layout view, you place the pointer over the left side of the control until the pointer turns into a ____.

Accepted Answer

A)  crosshair 
B)  solid black square 
C)  circle 
D)  double-headed arrow 
A)  crosshair 
B)  solid black square 
C)  circle 
D)  double-headed arrow

Question 9

Charts are simple to make and format.

Accepted Answer

A) True 
 B)False

Question 10

Avg is one of the functions available in a summary report.

Accepted Answer

A) True 
 B)False

Question 11

By selecting multiple controls, you have the ability to apply formats to several controls at one time.

Accepted Answer

A) True 
 B)False

Question 12

A(n) double-headed arrow is used to resize a control field.

Accepted Answer

A) True 
 B)False

Question 13

You can specify up to three conditions for a field.

Accepted Answer

A) True 
 B)False

Question 14

To create a chart, you use the ____ Wizard option.

Accepted Answer

A)  Graph 
B)  Report 
C)  Chart 
D)  Presentation 
A)  Graph 
B)  Report 
C)  Chart 
D)  Presentation

Question 15

Sum is an example of a function that may be used in a(n) chart .

Accepted Answer

A) True 
 B)False

Question 16

When creating a report, you add a currency format before you apply themes.

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____________________ control lets you use functions to add a calculation to a report.

Accepted Answer

The answer of A(n) ____________________ control lets you use functions...

Question 18

Access offers formatting features that you can apply to a ____ to make it a professional representation of the data.

Accepted Answer

A)  page 
B)  chart 
C)  sheet 
D)  document 
A)  page 
B)  chart 
C)  sheet 
D)  document

Question 19

The label typically appears either above or ____ the text box.

Accepted Answer

A)  to the left of 
B)  to the right of 
C)  under 
D)  on top of 
A)  to the left of 
B)  to the right of 
C)  under 
D)  on top of

Question 20

Using the ____ button, you can apply formats to more than one object, such as several labels.

Accepted Answer

A)  Format Painter 
B)  Format 
C)  Painter 
D)  Paint 
A)  Format Painter 
B)  Format 
C)  Painter 
D)  Paint

Exam 10: Adding Advanced Features to Reports

To select several controls, you press and hold ____________________ and then click on each control you want to select.

When a report selector is selected, it appears with a dark ____.

By adding basic formatting to a report before you apply a(n) schema , the theme formats are enhanced.

Click the Design tab, and then click the Themes button ____ in the Themes group to display the Themes gallery.

When you change control formats, you will typically be changing the text box when the ____ is displayed.

When a report is based on a parameter query, each time you open the report, the ____ box appears.

To begin increasing a text box width in Layout view, you place the pointer over the left side of the control until the pointer turns into a ____.

Charts are simple to make and format.

Avg is one of the functions available in a summary report.

By selecting multiple controls, you have the ability to apply formats to several controls at one time.

A(n) double-headed arrow is used to resize a control field.

You can specify up to three conditions for a field.

To create a chart, you use the ____ Wizard option.

Sum is an example of a function that may be used in a(n) chart .

When creating a report, you add a currency format before you apply themes.

A(n) ____________________ control lets you use functions to add a calculation to a report.

Access offers formatting features that you can apply to a ____ to make it a professional representation of the data.

The label typically appears either above or ____ the text box.

Using the ____ button, you can apply formats to more than one object, such as several labels.

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