|   The AS/400 & Microsoft Office Integration Handbook
Author: Brian Singleton, Colleen GartonPrice: $79.00
On Sale: $29.95
Availability: Ships in 48 hours
ISBN: 1-883884-49-7
SKU: 587 | |
 
Book Description:
This book takes a detailed look at how you can integrate applications in the Microsoft Office 97 product suite with data from your AS/400. Tasks that used to be nearly impossible are now made easy if you learn the integration secrets in this book¬ósecrets such as how to use your AS/400's output with your PC data formatting tools and how to easily make professional-looking reports with AS/400 data. You'll also learn the secret of using visual query tools to create sophisticated information output; how to analyze and summarize the detailed and often cumbersome reports from your AS/400; and how to combine the presentation capabilities of Microsoft Office with the database capabilities of the AS/400 to provide your company with the best of both worlds.
The first sections of the book introduce the essential knowledge you need to use Client Access as you integrate AS/400 data with the Microsoft Office applications. Author Brian Singleton explains how to install and configure Client Access, how to provide a seamless method of AS/400 integration with Microsoft Office using ODBC, the network drive functionality of Client Access, and the Client Access Data Transfer function. He also describes TCP/IP's FTP file transfer function and how to use it to bring data from the AS/400 to your PC.
The remaining sections cover the veritable Swiss Army knife functions of Microsoft Office. For each of the office applications, there's a specific chapter devoted to showing how each function can be used with the AS/400--from using Word to create mailing labels, form letters, and envelopes to downloading data into spreadsheets, producing sophisticated queries and data retrievals, and creating sophisticated reports, using Outlook as your AS/400. If you have PCs attached to your AS/400, this handbook has the essential information that will show you how to harness the power of Microsoft Office and exploit the AS/400 database.
Key Concepts Covered in this Book Include:
• The different components of Client Access including ODBC, data transfer, and operation navigator
• How to install and configure Client Access for Microsoft Office integration
• Security issues with ODBC
• How to configure a Client Access ODBC DSN Under Windows 95/NT
• How to install and use MSQUERY
• How the Query Wizard works and how it can make creating a Query easier
• How to sort, filter, join, summarize and total using MSQUERY
• How to merge AS/400 data to create labels, letters, and envelopes
• How to create lists, reports, and graphs using Microsoft Excel and AS/400 data
• The advantage of using Client Access Excel add-in
• Why Microsoft Access is one of the most powerful database products available on the PC
• How to rename a linked table within a database without affecting the table on the AS/400
• Step-by-step instructions for importing data through Access
• How to sort, filter, join, summarize and total using Access
• Techniques to help speed up your database operations with Access.
• Seven steps needed to set up Outlook as an email client on an AS/400 server
• How to set up Network Neighborhood to securely access your AS/400
• Techniques to use data transfer to automatically transfer data between PCs and the AS/400
• How to unlock the secrets of CCSIDs so that the AS/400 data is properly decoded
• The advantages and disadvantages of using FTP with TCP/IP rather than CA/400 download
• The 11 FTP commands and how they are used
Contents:
Chapter 1: Client Access Overview
Chapter 2: ODBC
Chapter 3: Retrieving AS/400 Data with Query
Chapter 4: Using AS/400 Data with MS Word
Chapter 5: Analyzing AS/400 Data with Excel
Chapter 6: Expanding Your Options with Access
Chapter 7: Retrieving E-Mail with Outlook
Chapter 8: The AS/400 in the Network Neighborhood
Chapter 9: The Client Access Data Transfer Function
Chapter 10: Transferring Data with FTP
Appendix A: Installing Sample Data
Appendix B: Support and Troubleshooting Index
Product Details: | Audience: | AS/400 Programmers | | Level: | Novice to Advanced | | Subject: | Microsoft Windows | | Length: | 320 pages | | Format: | Paperback, Layflat | | Materials: | Code on the Web | | Publisher: | MC Press | | Publish Date: | July 1998 |
The AS/400 & Microsoft Office Integration Handbook
Author: Brian Singleton, Colleen GartonPrice: $79.00
On Sale: $29.95
Availability: Ships in 48 hours
ISBN: 1-883884-49-7
SKU: 587 | |
| |
© 2001-2003 MC Press Online, LP. IBM® and AS/400® are registered trademarks of IBM.
All other product names are trademarked or copyrighted by their respective holders.
MC Press Online Privacy Policy
|
|
|
