|   The OS/400 and Microsoft Office 2000 Integration Handbook, Second Edition
Author: Brian Singleton, Chris PetersPrice: $79.00
On Sale: $44.95
Availability: Ships in 48 hours
ISBN: 1-58347-020-4
SKU: 5041 | |
  
Book Description:
Now you can use Client Access Express to combine the presentation capabilities of all versions of Microsoft Office (including Office 2000) with the database capabilities of the iSeries or AS/400 to provide your company with the best of both worlds. MC Press has completely updated its perennial best-seller, The AS/400 and Microsoft Office Integration Handbook, to reflect all the changes and enhancements of Client Access Express and Office 2000.
Tasks that used to be almost impossible are now an easy reality...if you know the integration secrets that authors Brian Singleton and Chris Peters reveal in this book. Find out how you can use your iSeries output with your PC data-formatting tools, make visually appealing reports using iSeries data, use visual query tools to point and click to create sophisticated information output, analyze and summarize the detailed and often cumbersome iSeries reports, tap into the power of Microsoft's powerful new Universal Data Access using OLE DB and ActiveX Data Object (ADO), and much more.
Singleton and Peters provide you with the essential knowledge you need to use Client Access Express as a means to integrate iSeries or AS/400 data with Microsoft Office 2000 applications. The OS/400 and Microsoft Office 2000 Integration Handbook covers installing and configuring Client Access Express, using ODBC to seamlessly integrate iSeries with Microsoft Office, and leveraging the Client Access Express data transfer function. The book also explains how to bring data from the AS/400 to your PC by using NetServer, TCP/IP's FTP file transfer function, and/or Universal Data Access with OLE DB and ADO.
Other chapters of the book explore the multitude of Microsoft Office functions. The authors devote a specific chapter to each Office application to show you how to use each function with the iSeries or AS/400. You'll learn how to use Word, Query, Excel, Access, and Outlook to generate mailing labels, form letters, and envelopes; to download data into spreadsheets; to produce queries and perform data retrieval; to create beautiful, sophisticated reports; and much more.
If you have PCs attached to your AS/400, this book has the essential information that will allow you to harness the power of Microsoft Office and exploit the AS/400 database.
Upon completion of this book, you will be able to:
• Create lists, reports, and graphs using Microsoft Excel and AS/400 or iSeries data
• Transfer data between PCs and the AS/400 and learn how to automate the process
• Sort, filter, join, summarize, and total using MSQUERY
• Import data and then sort, filter, join, summarize and total using Access
• Know the seven steps to set up Outlook as an email client on an AS/400 or iSeries server
• Set up Network Neighborhood to access your AS/400 and make sure your files are secure
• Merge data to create labels, letters, and envelopes in Word
• Install and configure Client Access Express for Microsoft Office integration
Contents:
Introduction
Chapter 1: Client Access Express 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 Express Data Transfer Function
Chapter 10: Transferring Data with FTP
Chapter 11: Microsoft's OLE DB/ADO Technology
Appendix A: Support and Troubleshooting Index
Product Details: | Audience: | AS/400 Programmers, Operators, and MS Office Users | | Level: | Intermediate to Advanced | | Subject: | Microsoft Windows | | Length: | 376 pages | | Format: | Paperback, Layflat | | Materials: | Code on the Web | | Publisher: | MC Press | | Publish Date: | July 2001 |
The OS/400 and Microsoft Office 2000 Integration Handbook, Second Edition
Author: Brian Singleton, Chris PetersPrice: $79.00
On Sale: $44.95
Availability: Ships in 48 hours
ISBN: 1-58347-020-4
SKU: 5041 | |
| |
© 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
|
|
|
