Question 1

Before you can move or resize a control,you MUST ________ it.

Accepted Answer

A)  delete 
B)  select 
C)  add 
D)  format 
A)  delete 
B)  select 
C)  add 
D)  format

Question 2

A ________ is a form created from one table,but has both a Form view and a Datasheet view in the same window.

Accepted Answer

A)  report 
B)  subform 
C)  split form 
D)  normal form 
A)  report 
B)  subform 
C)  split form 
D)  normal form

Question 3

In a split form,you cannot highlight a different record in the form part and the datasheet part at the same time.

Accepted Answer

A) True 
 B)False

Question 4

When you open a(n)________ in Access it opens in a new window with a tab.

Accepted Answer

A)  object 
B)  form 
C)  query 
D)  report 
A)  object 
B)  form 
C)  query 
D)  report

Question 5

To calculate totals for smaller groups of records,you can add ________ to the report.

Accepted Answer

The answer of To calculate totals for smaller groups of...

Question 6

The final result of a report is usually a(n)________.

Accepted Answer

The answer of The final result of a report is...

Question 7

A split form displays data from two different tables,with the information from the main table at the top of the window,and the information from the secondary form in the bottom of the window.

Accepted Answer

A) True 
 B)False

Question 8

________ in a report created using the Report wizard are in the order that the fields are added to the report.

Accepted Answer

The answer of ________ in a report created using the...

Question 9

When you have a form with a ________,you have two Navigation bars.

Accepted Answer

A)  subform 
B)  theme 
C)  report 
D)  query 
A)  subform 
B)  theme 
C)  report 
D)  query

Question 10

You can sort up to ________ fields in either ascending or descending order in a report.

Accepted Answer

The answer of You can sort up to ________ fields...

Question 11

To add a subtotal to the Group,Sort,and Total pane,you must first be in ________ view.

Accepted Answer

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

Question 12

A control whose data source is a calculated expression that you create is called a(n)________ control.

Accepted Answer

A)  bound 
B)  calculated 
C)  unbound 
D)  text box 
A)  bound 
B)  calculated 
C)  unbound 
D)  text box

Question 13

A form created from one table that has both a Form view and a Datasheet view is called a(n)________.

Accepted Answer

The answer of A form created from one table that...

Question 14

In a report,you can change the appearance of a control by adding borders or fill color.

Accepted Answer

A) True 
 B)False

Question 15

You should add fields to the report wizard in the order in which you want the fields to appear in the report.

Accepted Answer

A) True 
 B)False

Question 16

Because saving a report as a PDF file is publishing the file,you will use the ________ option to save the report as a PDF instead of Save or Print.

Accepted Answer

The answer of Because saving a report as a PDF...

Question 17

________ allows you to format fields depending on conditions you specify.

Accepted Answer

A)  Special formatting 
B)  Value formatting 
C)  Conditional formatting 
D)  Field formatting 
A)  Special formatting 
B)  Value formatting 
C)  Conditional formatting 
D)  Field formatting

Question 18

You must be viewing a form in ________ view to make changes to the data in a form.

Accepted Answer

A)  Design 
B)  Datasheet 
C)  Form 
D)  Report 
A)  Design 
B)  Datasheet 
C)  Form 
D)  Report

Question 19

Because Jose is not sure his supplier has Access 2010,he has decided to publish his report as an Adobe ________ file,rather than saving it.

Accepted Answer

The answer of Because Jose is not sure his supplier...

Question 20

The view that offers more options for adding and editing controls on a report,including options not available in any of the other views is the Design view.

Accepted Answer

A) True 
 B)False

Exam 8: Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Before you can move or resize a control,you MUST ________ it.

A ________ is a form created from one table,but has both a Form view and a Datasheet view in the same window.

In a split form,you cannot highlight a different record in the form part and the datasheet part at the same time.

When you open a(n)________ in Access it opens in a new window with a tab.

To calculate totals for smaller groups of records,you can add ________ to the report.

The final result of a report is usually a(n)________.

A split form displays data from two different tables,with the information from the main table at the top of the window,and the information from the secondary form in the bottom of the window.

________ in a report created using the Report wizard are in the order that the fields are added to the report.

When you have a form with a ________,you have two Navigation bars.

You can sort up to ________ fields in either ascending or descending order in a report.

To add a subtotal to the Group,Sort,and Total pane,you must first be in ________ view.

A control whose data source is a calculated expression that you create is called a(n)________ control.

A form created from one table that has both a Form view and a Datasheet view is called a(n)________.

In a report,you can change the appearance of a control by adding borders or fill color.

You should add fields to the report wizard in the order in which you want the fields to appear in the report.

Because saving a report as a PDF file is publishing the file,you will use the ________ option to save the report as a PDF instead of Save or Print.

________ allows you to format fields depending on conditions you specify.

You must be viewing a form in ________ view to make changes to the data in a form.

Because Jose is not sure his supplier has Access 2010,he has decided to publish his report as an Adobe ________ file,rather than saving it.

The view that offers more options for adding and editing controls on a report,including options not available in any of the other views is the Design view.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters