Transcript Document

Integration Tutorial 2
Integrating Word,
Excel, and Access
FIRST COURSE
Objectives
XP
• Collect text and objects from Office documents
and place them on the Office Clipboard
• Paste selections from the Office Clipboard into
Word
• Learn about importing and exporting data
• Import an Excel list into an Access database
• Query an Access database
• Export an Access query to a Word document
New Perspectives on Microsoft Office 2007: Windows XP Edition
2
Planning the Brochure
XP
• When you import data from one Office program
to another, you actually convert the data from its
original source program format to a format
supported by the destination program
• When you export data, it is converted from one
program’s format to another, as in importing
New Perspectives on Microsoft Office 2007: Windows XP Edition
3
Using the Office Clipboard
XP
• The Office Clipboard is used to collect text and other
items from Office documents, and then paste those
items into any Office document
• The system Clipboard is part of Windows, and it
contains only the last item cut or copied
• Items that you cut or copy are put onto the system
Clipboard, and each subsequent cut or copied item
replaces the current item that was on the system
Clipboard
New Perspectives on Microsoft Office 2007: Windows XP Edition
4
Using the Office Clipboard
New Perspectives on Microsoft Office 2007: Windows XP Edition
XP
5
Using Excel Data in Access
XP
• Open the Access database into which you want to
import the Excel list
• Click the External Data tab on the Ribbon
• In the Import group, click the Excel button
• In the Select the source and destination of the data
screen of the Get External Data – Excel Spreadsheet
dialog box, click the Browse button
• In the File Open dialog box, click the Look in list arrow to
locate the Excel workbook you want to use, if necessary,
click the file, and then click the Open button
New Perspectives on Microsoft Office 2007: Windows XP Edition
6
Using Excel Data in Access
XP
• In the Get External Data – Excel Spreadsheet dialog box, click
the option corresponding to the way you want to import the
data (into a new table, appended to an existing table, or into
a new linked table)
• Follow the directions in the Access Import Spreadsheet
Wizard
• After clicking the Finish button in the Import Spreadsheet
Wizard, click the Save import steps check box in the Save
Import Steps screen of the Get External Data – Excel
Spreadsheet dialog box if you want to save the import steps,
and then click the Save Import button, or click the Close
button in the dialog box
New Perspectives on Microsoft Office 2007: Windows XP Edition
7
Using Excel Data in Access
New Perspectives on Microsoft Office 2007: Windows XP Edition
XP
8
Using Excel Data in Access
New Perspectives on Microsoft Office 2007: Windows XP Edition
XP
9
Exporting an Access Query to Word
XP
• Open the Access database from which you want
to import the query
• Click the External Data tab on the Ribbon
• In the Export group, click the Word button
• In the Export – RTF File dialog box, click the
Browse button
• In the File Name text box, replace the default
filename with a new filename, if you want
New Perspectives on Microsoft Office 2007: Windows XP Edition
10
Exporting an Access Query to Word
XP
• Click the Open the destination file after the
export operation is complete check box to select
it if you want the file to open automatically after
it is exported
• Click the OK button
• In the Save Export Steps screen in the Export –
RTF File dialog box, click the Save export steps
check box if you want to save the export steps,
and then click the Save Export button, or click
the Close button in the dialog box
New Perspectives on Microsoft Office 2007: Windows XP Edition
11
Exporting an Access Query to Word
New Perspectives on Microsoft Office 2007: Windows XP Edition
XP
12
Exporting an Access Query to Word
New Perspectives on Microsoft Office 2007: Windows XP Edition
XP
13