Microsoft Excel and Access Integration: With Microsoft Office 2007
In this book, 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.

This book will liberate you from the daily grind of routine data practices and help you to explore all the functionality that exists when Excel and Access are brought together.  Learn how 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 Excel’s presentation layer
    * Move Data between Excel and Access using VBA, ADO and SQL
    * Automate redundant processes using VBA
    * Simplify integration tasks using XML
    * Integrate Excel data into other Office applications

• Chapter 1:  Getting Excel Data Into Access

• Chapter 2:  Introduction to Access Queries

• Chapter 3:  Sprucing Up Excel Data with Access Reports

• Chapter 4:  Working With Pivot Tables in Access

• Chapter 5:  Getting Access Data Into Excel

• Chapter 6:  Leveraging Macros in Excel and Access

• Chapter 7:  Introduction to VBA

• Chapter 8:  Using VBA to Move Data Between Excel and Access

• Chapter 9:  Exploring Excel and Access Automation

• Chapter 10:  Integrating Excel and Access with XML

• Chapter 11:  Integrating Excel and Other Office Applications