Location:  Home » Computer Hardware » The AS/400 & Microsoft Office Integration Handbook  

The AS/400 & Microsoft Office Integration Handbook

The AS/400 & Microsoft Office Integration HandbookAuthors: Brian Singleton, Colleen Garton
Publisher: MC Press
Category: Book

List Price: $79.00
Buy Used: $3.05
as of 9/10/2010 03:59 CDT details
You Save: $75.95 (96%)



New (3) Used (13) from $3.05

Seller: econgo
Rating: 3.5 out of 5 stars 9 reviews

Media: Paperback
Edition: 1
Pages: 375
Number Of Items: 1
Shipping Weight (lbs): 1.1
Dimensions (in): 8.8 x 6.9 x 0.7

ISBN: 1883884497
Dewey Decimal Number: 005.369
EAN: 9781883884499

Availability: Usually ships in 1-2 business days

Editorial Reviews:

Product 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


Customer Reviews:
Showing reviews 1-5 of 9



5 out of 5 stars Good step-by-step tutorials   August 29, 1998
5 out of 6 found this review helpful

Lots of figures and step by step instructions made it easy for me to create easy reports from our AS/400 data. Saved tons of time!


5 out of 5 stars Great book. Very informative   August 31, 1998
2 out of 3 found this review helpful

This book helped unlock some of the Office-AS/400 mysteries for me. It has helped me to understand how to maximize the AS/400 with Office. I recommend this book to anyone who wishes to use Office with the AS/400. It is a real timesaver.


5 out of 5 stars Offers Everyday Solutions   September 7, 1998
2 out of 3 found this review helpful

Lots of easy to follow instructions and screenshots.


5 out of 5 stars A Must Have!!!   August 29, 1998
The book explained everything from the beginning, leading on to the more advanced stuff. Office 97 is amazing! Excel pivottables with AS/400 data saved us days of programming time.


5 out of 5 stars How to stop tears.   September 14, 1998
1 out of 4 found this review helpful

Well paced and easy to read. This will save you plenty of tears as the writers have alresdy been there. A must for all AS400 users.

Showing reviews 1-5 of 9