MICROSOFT OFFICE
Microsoft Office is a suite of four applications - Access, Excel, PowerPoint and Word - that can be used in conjunction with each other to produce complex, professional documents for work or home.
Integrating Office
- Half Day Class (8:15 am - 12:00 pm OR 1:00 pm - 4:30 pm)
- Sample: Table Of Contents (PDF)
- Sample: Class Excerpt
Click the link to view a sample of this class' "slide show". The slide images are large, so please be patient while they load.
"This course will help me organize better and will save me time because I learned so many helpful things."
Overview
The complete scope of a project can involve material produced with a variety of Office applications. For example, data stored in Microsoft Excel might serve as a mailing list for a Word form letter. Integrating Office demonstrates how the different Office applications can be used together to address such challenges. This includes methods to incorporate data seamlessly, in order to completely blend two sources of data into a single, unified document. This half-day course compiles demonstrations found in other classes, as well as several new examples of integration, into a concise half-day overview.
Objectives
- Review general concepts: what is "Office Integration"?, servers and clients, warehouses and presenters.
- Practice basic integration: object linking and embedding or "OLE", review challenges to integration.
- Create integrated form letters: use Access and Excel data in Word mail merges.
- Examine "non-traditional" integration: use Word documents in Access, pull Access data into Excel.
- Cover supplemental programs: Microsoft Organization chart and Microsoft Graph.
Prerequisite(s)
Other Information
- Integrating Office covers tools from all four of the Office applications (Access, Excel, PowerPoint, Word). Some familiarity with each of these programs is helpful but not required.
- If you have questions about this class' content or prerequisites, please contact us.
If you have usability issues with this web site, or if it does not render properly in your browser, please tell the "webmaster" (we use that term loosely). We're striving to make it as standards- and accessibility-compliant as we can, but we haven't had the opportunity to test all platforms, browsers, environments, etc.
