eBOOK
DetailsPublisher
WileyRelease Date April 30, 2007
ISBN 0470104880eBOOK
Description
In this free ebook, you will find a comprehensive review of the wide range of integration techniques that can be performed using Excel and Access. Through step-by-step instruction, you will explore the benefits of integrating Excel and Access, the differences and similarities between Excel and Access, and some of the common pitfalls of moving and analyzing data across applications. After reading this free ebook, you will be able to:
Easily move data between Excel and Access
Store Excel data in a structured, relational database
Use Excel pivot tables with Access data
Report Access data using the Excel presentation layer
Move data between Excel and Access using VBA, ADO and SQL
Automate redundant processes using VBA to save time and increase
productivity
Simplify integration tasks using XML
Integrate Excel data into other Office applications
download ebook
Easily move data between Excel and Access
Store Excel data in a structured, relational database
Use Excel pivot tables with Access data
Report Access data using the Excel presentation layer
Move data between Excel and Access using VBA, ADO and SQL
Automate redundant processes using VBA to save time and increase
productivity
Simplify integration tasks using XML
Integrate Excel data into other Office applications
download ebook
No comments:
Post a Comment