Microsoft Excel & Access Integration With Office 2007 - Couverture souple

Alexander, Michael; Clark, Geoffrey

 
9780470104880: Microsoft Excel & Access Integration With Office 2007
Couverture souple
ISBN 10 : 0470104880 ISBN 13 : 9780470104880
Editeur : John Wiley & Sons Inc, 2007

Synopsis

Paperback

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Quatrième de couverture

Excel users. Access users. You′re probably among the majority, living in one camp or the other but rarely crossing between the two. Yet Microsoft designed these applications to work together. In this book, you′ll discover how Access benefits from Excel′s flexible presentation layer and versatile analysis capabilities, while Access′s relational database structure and robust querying tools enhance Excel. Once you learn to make the team work, you′ll find that your team′s productivity is the real winner.

  • Move data easily between Excel and Access

  • Store Excel data in a structured relational database

  • Create Excel PivotTables with Access data

  • Report Access data using Excel′s presentation layer

  • Use VBA, ADO, and SQL to move data from one application to the other

  • Save time and increase productivity by automating redundant processes with VBA

  • Simplify integration tasks using XML

  • Integrate Excel data into other Office applications

Companion Web site

Find all the examples from the book in the database located at www.wiley.com/go/exceland accessintegration.

Présentation de l'éditeur

Although many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually designed these applications to work together. In this book, you ll discover how Access benefits from Excel s flexible presentation layer and versatile analysis capabilities, while Access s relational database structure and robust querying tools enhance Excel. Once you learn to make the two work together, you ll find that your team s productivity is the real winner.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Éditeur
John Wiley & Sons Inc
Date d'édition
2007
Langue
anglais
ISBN 10 
0470104880
ISBN 13 
9780470104880
Reliure
Broché
Nombre de pages
388
Coordonnées du fabricant
non disponible
Personne responsable
non disponible