Integrating with Word, Excel, and Access 2007

This course has been superseded

We suggest the following instead:
Access 365 - Part 2

Course Description

Many programs in Office 2007 have the ability to share information back and forth with each other. This course will show you how you can get a lot of things done faster in Office by using the sharing technologies built into Word, Excel, and Access. You will learn how to create professional and functional documents that make the most of the sharing, linking, and embedding technologies included with these programs. The end result will be your ability to get your message across in a way that is attractive and functional for both you and your audience.
1 Day
Contact us for pricing
 

Prerequisites

Participants are expected to have used MS Word, Excel and Access in their day to day role. This course is not intended as an Introduction to MS Office, but as a route to making more effective use of the packages by integrating their facilities.

How You Will Benefit

• You will understand the basics of integration and learn why sometimes it is better than Copy and Paste
• You will be able share information within Office to get things done faster and smarter
You will be able to create functional and informative documents that can pull real-time information from different locations

Integration of Microsoft Office Products

Keeping it Simple
Why Integrate? Because It's Easy!
Hyperlinks in Word
Hyperlinks in Excel
Hyperlinks in Access

Microsoft Office Word 2007

Controlling Paste Options
Linking and Embedding Objects
Mail Merges
Using Forms

Microsoft Office Excel 2007

Moving your Data
Using Paste Special
Insert/Delete Rows, Columns, and Cells
Undo, Redo, and Repeat
Using Excel with Other Programs
Web Pages and Web Queries

Microsoft Office Access 2007

Exporting and Linking Files
Exporting Access Data
Using Saved Exports
Linking to Another Database
Microsoft Access