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

Question 1

When you open a reply in the Access Data Collection Replies folder in Outlook,you can see the reply,but you CANNOT reply to it,re-send it,or forward it.

Answer 1

True

Question 2

Using a(n)________ allows you to have a consistent look to your business documents such as letterheads and e-mails.

A) image
B) database
C) theme
D) logo

Answer 2

C

Question 3

Microsoft Windows saves themes and templates in special ________ to make easy for Microsoft to find them.

A) drives
B) files
C) databases
D) folders

Answer 3

D

Question 4

Using ________ you can send a personalized mass e-mail message to a list of contacts in your address book.

A) Excel
B) PowerPoint
C) Mail Merge
D) an Access database

Question 5

Before sending a mass e-mail with a data collection form on it,you should first ________.

A) send it to yourself and reply to it to make sure it works
B) double-check the e-mail addresses
C) send it to your manager so s/he can let you know if it works
D) send it to your friends so they can let you know if they get it

Question 6

You can send out a survey form through e-mail for your recipients to fill out and return if you are using Microsoft ________.

A) Word
B) Excel
C) Outlook
D) PowerPoint

Question 7

Coordinated fonts,colors,effects,and backgrounds you can add to a presentation,workbook,document or e-mail are called ________.

A) designs
B) formats
C) themes
D) styles

Question 8

You can store e-mail addresses used for collecting data in a database or ________.

A) in a spreadsheet
B) on your hard drive
C) on a USB drive
D) in your address book

Question 9

You must have both Access 2007 or later and Outlook 2007 or later installed on your computer before you can send a data collection form to collect data through an e-mail message.

Question 10

Themes are saved ________ in which they are created.

A) independent of the program
B) in a hidden folder in the program
C) in a special folder in the program
D) inside of the program

Question 11

________ compatibility makes it possible for Outlook and Word to share information about the merged e-mail.

A) MAPI (Messaging Application Program Interface)
B) HTML
C) Office 2010
D) Data

Question 12

When you create an e-mail message in mail merge,only ________ listed in the To line are recognized.

A) addresses
B) names
C) contacts
D) links

Question 13

Before you can process data from e-mails you receive,Outlook must be ________.

A) open and running on your computer
B) installed, but not running on your computer
C) closed
D) linked to an Access database

Question 14

To re-send a data collection form you must use the Manage Data Collection Messages dialog box.

Question 15

HTML and PDF are two of the formats used to send Access data by e-mail as a(n)________.

A) data form
B) information request
C) data message
D) attached object

Question 16

When the table you are using does not have a primary key field,you can only collect ________.

A) new data
B) Excel data
C) PowerPoint data
D) old data

Question 17

In Outlook,data is collected using either an HTML form or a(n)________ form.

A) Excel
B) InfoPath
C) Access
D) Word

Question 18

To collect new data from a recipient or to update existing data,you would use a(n)________ form.

A) Access
B) data collection
C) Word
D) PowerPoint

Question 19

Themes and templates are managed in a similar way in ________.

A) a form
B) a report
C) a database
D) Office 2010

Question 20

If you choose to process data collection replies automatically,you will be required to start the export operation to transfer the data to the Access table.

Question 21

If you need to process more than the default number of message replies in Outlook,you can change the number of messages processed under ________.

Question 22

By default,the number of messages Outlook will process automatically is ________ messages.

Question 23

To respond to your e-mail,the ________ needs to click Reply,fill out the form,and then click Send.

Question 24

If you have Access and Outlook installed on your computer,you can send data from an Access table through an e-mail ONLY by copying and pasting the data into the Outlook message box.

Question 25

You only have to store e-mail addresses in the database if you are updating records.

Question 26

In the data collection form,you can include AutoNumber,Attachment,and OLE type fields.

Question 27

A(n)________ is a saved collection of fonts,colors,effects,and backgrounds which can be applied to an e-mail message.

Question 28

If the data collection recipient replies through Hotmail,Yahoo,or Google,the data cannot be added to the Access table.

Question 29

When doing a mail merge of a letter in Outlook,you can use different versions of Outlook and Word.

Question 30

A saved collection of fonts,colors,effects and backgrounds is called a template.

Question 31

To process data from the e-mails you send,________ must be installed on your computer,but does not have to be open and running.

Question 32

Even if you make changes to field names,sizes,or data types in a table you are using for data collection,Access will be able to find the appropriate field to put the collected data in.

Question 33

The more replies that must be processed,the longer it will take for ________ to complete the send.

Question 34

When creating a data entry form to collect data through Outlook,you must choose either an HTML form or a(n)________ form.

Question 35

When using Access data to create an e-mail mail merge in Outlook,you can add additional recipients to the Cc line of the e-mail message.

Question 36

Themes created in PowerPoint can be used in Word,but NOT in Outlook e-mails.

Question 37

Since not everyone has Access installed on their computers,you can send an e-mail ________ with Access data formatted as another type of object.

Question 38

The ________ Wizard in Access will walk you through the steps to create a data collection form.

Question 39

________ are saved independently from the program in which they are created.

Question 40

It is best to have only one person maintain a(n)________ to prevent problems with data collection.

Question 41

MAPI (Messaging Application Program Interface)makes it possible for Outlook and ________ to share information about the merged e-mail.