MARC record from Internet Archive

LEADER: 08204cam 2200781Ma 4500
001 ocn324989144
003 OCoLC
005 20220622141706.0
008 090427s2005 txua ob 001 0 eng d
006 m o d
007 cr zn|||||||||
040 $aYUS$beng$epn$cYUS$dOCLCQ$dB24X7$dOCLCQ$dE7B$dN$T$dOCLCQ$dOCLCO$dOCLCQ$dVALIL$dOCLCF$dYDXCP$dOCLCQ$dOCLCO$dOCL$dOCLCQ$dOCLCO$dCOO$dVLY$dBRF$dEYM$dOCLCO
019 $a794492334$a1060183806$a1179559190$a1194862546
020 $a9781583477090$q(electronic bk.)
020 $a1583477098$q(electronic bk.)
020 $a9781583477373$q(electronic bk.)
020 $a1583477373$q(electronic bk.)
020 $z9781583470572
020 $z1583470573
035 $a(OCoLC)324989144$z(OCoLC)794492334$z(OCoLC)1060183806$z(OCoLC)1179559190$z(OCoLC)1194862546
037 $aitpro
050 4 $aHF5548.4.M525$bP38 2005eb
072 7 $aCOM$x084030$2bisacsh
072 7 $aCOM$x005000$2bisacsh
082 04 $a005.5$222
100 1 $aPeters, Chris,$d1949-
245 14 $aThe i5/OS and Microsoft Office integration handbook /$cChris Peters and Brian Singleton.
250 $a3rd ed.
260 $aLewisville, Tex. :$bMC Press Online,$c©2005.
300 $a1 online resource.
336 $atext$btxt$2rdacontent
337 $acomputer$bc$2rdamedia
338 $aonline resource$bcr$2rdacarrier
500 $aTitle from title screen.
500 $aIncludes index.
504 $aIncludes bibliographical references and index.
520 $aIn this, the third edition of the perennial best-seller, iSeries gurus Chris Peters and Brian Singleton have completely updated this essential resource to reflect all of the latest changes and enhancements of iSeries Access and Express Client and Microsoft Office. Now, you can use iSeries Access or Express Client to combine the presentation capabilities of all versions of Microsoft Office with the database capabilities of the i5/iSeries to provide your company with the best of both worlds. Tasks that used to be almost impossible are now an easy reality ... if you know the integration secrets revealed in this book. Discover how to use your iSeries output with 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 Universal Data Access using ADO.NET, ODBC, and OLE DB, and much more. Singleton and Peters provide you with the essential knowledge you need to use iSeries Access or Express Access as a means to integrate iSeries or AS/400 data with Microsoft Office applications. i5/OS and Microsoft Office Integration Handbook, Third Edition covers installing and configuring iSeries Access or Express Client, using ODBC to seamlessly integrate iSeries with Microsoft Office, and leveraging the iSeries Access data transfer function. The book also explains how to bring data from the iSeries to your PC by using NetServer, TCP/IP's FTP file transfer function, and/or Universal Data Access with OLE DB and ADO.NET. Other chapters of the book explore the multitude of Microsoft Office functions by devoting a specific chapter to each Office application to show you how to use each function with the i5/iSeries. You'll learn how to use Excel, Word, Query, Access, and Outlook to generate spreadsheets, mailing labels, form letters, and envelopes; to produce querie.
505 0 $aCover; Copyright; CONTENTS; INTRODUCTION; COMBINING CAPABILITIES; ABOUT THIS BOOK; FOLLOWING ALONG WITH THE SAMPLE DATA; Chapter 1: CONNECTIVITY OVERVIEW; IBM ISERIES ACCESS AND EXPRESS CLIENT; ISERIES ACCESS COMPONENTS; ISERIES ACCESS LICENSES; INSTALLING MICROSOFT OFFICE INTEGRATION; CONFIGURING A CONNECTION; Chapter 2: ODBC; WHAT IS ODBC?; WHY USE ODBC?; ARCHITECTURE; CONFIGURING AN ISERIES ACCESS ODBC DSN; Step 1: Create the iSeries Directory Entry; Step 2: Create a Data Source; Creating a System DSN; ODBC SECURITY; Security and Data Updates; Password "Sniffing" Using Trace
505 8 $aODBC TIPS AND TECHNIQUESAutomating DSN Setup; Accessing Multimember Database Files; Making Data Updateable through ODBC; SUMMARY; Chapter 3: RETRIEVING ISERIES DATA WITH MICROSOFT QUERY; COMING TO TERMS; INSTALLATION; Installing Microsoft Query; Creating a Shortcut; AQUICK LESSON; CREATING A SIMPLE QUERY USING THE WIZARD; CREATING A QUERY WITHOUT THE WIZARD; SAVING THE QUERY; SORTING RECORDS; THE SQL STATEMENT GENERATED BY MS QUERY; UPDATING DATA; SPEEDING UP THE DESIGN PROCESS; FILTERING RECORDS; JOINING TABLES; TOTALING AND GROUPING; PERFORMANCE CAUTIONS; SUMMARY
505 8 $aChapter 4: USING ISERIES DATA WITH MS WORDUSING ODBC OR OLE DB/ADO TO RETRIEVE ISERIES DATA; CREATING MAILING LABELS WITH ODBC; CREATING FORM LETTERS; CREATING OTHER MAIL MERGE LISTS; INSERTING DATA INTO A TABLE; ADDITIONAL FEATURES OF THE MAIL MERGE WIZARD; MOVING ISERIES DATA INTO WORD WITH OLE DB/ADO; OLE DB/ADO Dynamic Connection; Using OLE DB/ADO with Word; Creating a Word Macro; An OLE DB/ADO Macro for Word; SUMMARY; Chapter 5: ANALYZING DB2/400 DATA WITH EXCEL; RETRIEVING DATA IN A LIST WITH MICROSOFT QUERY; CREATING A CHART FROM ISERIES DATA; Preparing the Data; Creating Charts
505 8 $aCREATING A PIVOTTABLEPivotTable, Step 1; PivotTable, Step 2; PivotTable, Step 3; PivotTable, Step 4; THE ISERIES ACCESS ADD-IN FOR EXCEL; Installing the iSeries Access Excel Add-In; Using the iSeries Access Excel Add-In; ACCESSING DB2/400 DATA WITH A VBAMACRO; ACCESSING DB2/400 DATA WITH ODBC; ACCESSING DB2/400 DATA WITH OLE DB; IMPORTING DATA WITHOUT ISERIES ACCESS; Create and Run a Data Extract on the iSeries; Import the Data into Excel; THE EASY DOWNLOAD UTILITY; OLE DB Versus ODBC; Standard Requirements for the Utility; Before You Run the Spreadsheet; Putting the Utility to Use
505 8 $aEntering the Code YourselfExamining the Code; Take It from Here; SUMMARY; Chapter 6: EXPANDING YOUR OPTIONS WITH MICROSOFT ACCESS; TERMINOLOGY; USING ISERIES DATA; What Is Linking?; Linking, Step by Step; What Is Importing?; Importing, Step by Step; Linking Versus Importing; Deleting Tables; THE DATASHEET VIEW; ACCESS QUERIES; Select Queries; Viewing Queries within Access; Sorting and Filtering Data; Joining Tables; Summary Queries; Parameter Queries; Join Types; Action Queries to Add, Update, and Delete Records; Update Query; Performance Cautions; ACCESS FORMS; Form Types; Creating a Form
630 00 $aMicrosoft Office.
630 00 $ai5/OS.
650 0 $aBusiness$xComputer programs.
650 7 $aCOMPUTERS$xDesktop Applications$xSuites.$2bisacsh
650 7 $aCOMPUTERS$xEnterprise Applications$xGeneral.$2bisacsh
650 7 $aCOMPUTERS$xGeneral.$2bisacsh
630 07 $aI5/OS$2fast$0(OCoLC)fst01402214
630 07 $aMicrosoft Office.$2fast$0(OCoLC)fst01381546
650 7 $aBusiness$xComputer programs.$2fast$0(OCoLC)fst00842283
655 4 $aElectronic books.
655 0 $aElectronic books.
700 1 $aSingleton, Brian.$4aut
856 40 $3Books24x7$uhttp://www.books24x7.com/marc.asp?bookid=30868
856 40 $3ebrary$uhttp://site.ebrary.com/id/10555710
856 40 $3EBSCOhost$uhttp://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=450779
856 40 $3Freading$uhttp://www.freading.com/ebooks/details/r:download/NDg5MTk3NDM=
856 4 $3Available from Skillsoft Books ITPro$idbcode=AALIM; providercode=PRVAEB$uhttps://cornell-library.skillport.com/skillportfe/main.action?assetid=30868$zConnect to online resource.
856 40 $uhttps://brad.idm.oclc.org/login?url=http://library.books24x7.com/library.asp?bookid=30868$yFull text access.$xUkBfUB
856 40 $zAccess to the Skillsoft books online version restricted; authentication may be required:$uhttps://umich.skillport.com/skillportfe/main.action?assetid=30868
938 $aBooks 24x7$bB247$nbks00030868
938 $aebrary$bEBRY$nebr10555710
938 $aEBSCOhost$bEBSC$n450779
938 $aYBP Library Services$bYANK$n7628025
029 1 $aAU@$b000053318941
994 $aZ0$bIME
948 $hNO HOLDINGS IN IME - 132 OTHER HOLDINGS