Microsoft office 2007 illustrated introductory windows vista edition
Download
1 / 19

Microsoft Office 2007-Illustrated Introductory - PowerPoint PPT Presentation


  • 281 Views
  • Updated On :

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition. Integrating Word, Excel, and Access. Objectives. Integrate data among Word, Excel, and Access Import an Excel worksheet into Access Copy a Word table to Access Link an Access table to Excel and Word

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Microsoft Office 2007-Illustrated Introductory' - RoyLauris


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Microsoft office 2007 illustrated introductory windows vista edition l.jpg

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

Integrating Word, Excel, and Access


Objectives l.jpg
Objectives Vista Edition

  • Integrate data among Word, Excel, and Access

  • Import an Excel worksheet into Access

  • Copy a Word table to Access

  • Link an Access table to Excel and Word

  • Link an Access table to Word

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Unit introduction l.jpg
Unit Introduction Vista Edition

  • Typical business to-do list:

    • Create sales charts

    • Order new products

    • Complete purchase orders

    • Produce proposals for new contracts

  • Using integration to perform tasks

    • Build Access database to store records

    • Link Access database to Excel workbook

    • Also link Access database to Word report

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Integrating data among word excel and access l.jpg
Integrating Data Among Word, Excel, and Access Vista Edition

  • Integrating data from three programs

    • Enter data into an Access database

    • Make calculations using data in Excel

    • Link Word report to Excel data and table

  • Importing Excel worksheet into Access

    • Enter data into table directly or via import

    • Access import tool: Get External Data

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Integrating data among word excel and access5 l.jpg
Integrating Data Among Word, Excel, and Access Vista Edition

  • Copying a Word table into Access

    • Copy and paste into new or existing table

  • Linking Access table to Excel and Word

    • Keep data current in all three applications

    • Use Copy and Paste Special commands

  • Linking an Access table to Word

    • You can reformat the linked table in Word

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Integrating data among word excel and access6 l.jpg
Integrating Data Among Word, Excel, and Access Vista Edition

  • Excel data imported to an Access table

Field Name changed from Participants to Guests during the import process

Excel data

Excel data imported

to Access and named Tours table

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Integrating data among word excel and access7 l.jpg
Integrating Data Among Word, Excel, and Access Vista Edition

  • Word report linked to Excel and Access

Table linked to

Excel and to

Access

Table copied

from Access

and pasted

as a link

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Importing an excel worksheet into access l.jpg
Importing an Excel Worksheet into Access Vista Edition

  • Ways to import Excel data to Access

    • Import Excel data into new Access table

    • Append Excel data to an existing table

  • How to import Excel data into Access

    • Click the Get External Data tab in Access

    • Click Excel button in the Import Group

    • Navigate to Excel file and select an option

    • Follow Import Spreadsheet Wizard

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Importing an excel worksheet into access9 l.jpg
Importing an Excel Worksheet into Access Vista Edition

  • Options in Get External Data dialog box

The file path will

be different on

your computer

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Importing an excel worksheet into access10 l.jpg
Importing an Excel Worksheet into Access Vista Edition

  • Changing field names in imported table

Field name changes

in column heading

Guests entered

in the Field

Name box

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Importing an excel worksheet into access11 l.jpg
Importing an Excel Worksheet into Access Vista Edition

  • Excel table imported to Access

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Copying a word table to access l.jpg
Copying a Word Table to Access Vista Edition

  • Copy table in Word, Paste in Access

    • Pasted Word table is not linked

    • Changes in one table do not affect other

  • Two methods for adding Word table

    • Paste table into new, blank Access table

    • Paste table into existing Access table

  • Rule for pasting into existing table

    • Tables to have same number of records

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Copying a word table to access13 l.jpg
Copying a Word Table to Access Vista Edition

  • Selecting the location for copied data

Add New Field

selected

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Linking an access table to excel and word l.jpg
Linking an Access Table to Excel and Word Vista Edition

  • Benefits of linking three programs:

    • Use each program’s strengths

    • Reduce amount of data entry

  • Use Copy and Paste Special tools

    • Step 1: link Access table to Excel file

    • Step 2: link Excel data to Word file

  • Effects of changing table in Access

    • Data in Excel and Word will also change

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Linking an access table to excel and word15 l.jpg
Linking an Access Table to Excel and Word Vista Edition

  • Copied data formatted in Excel

Accounting Number Format

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Linking an access table to excel and word16 l.jpg
Linking an Access Table to Excel and Word Vista Edition

  • Excel data pasted into Word

Linked table

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Linking an access table to word l.jpg
Linking an Access Table to Word Vista Edition

  • Use Copy and Paste Special tools

  • Effect of updating Access table

    • Linked table in Word also updated

  • Reason for excluding Excel link

    • Excel-type calculations are not needed

  • Pasted table can be formatted in Word

  • Rule for enabling content in linked files

    • Open linked files in order of creation

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Linking an access table to word18 l.jpg
Linking an Access Table to Word Vista Edition

  • Completed Word report

Revenue updated

to $75,000

Burns changed

to Abrams

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Summary l.jpg
Summary Vista Edition

  • Edits to Access data are reflected in linked Excel or Word data

  • Get External Data: Access import tool

  • Import Spreadsheet Wizard: adapts Excel data to an Access table

  • A Word table is pasted into an Access table without links

  • Link Word, Access, and Excel data to utilize each program’s strengths

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


ad