Microsoft Excel and Access Integration: With Microsoft Office 2007

Description:

• Offering step-by-step instruction, this invaluable book shows readers how to save time and enhance data analysis and reporting capabilities by combining the abilities of Excel and Access
• While both Excel and Access are powerful tools on their own, combining the functionality of these two applications opens up a whole new world of possibilities
• In addition to demonstrating a wide range of integration techniques, the book also provides practical, real-world scenarios that illustrate ways to avoid common pitfalls when moving and analyzing data across applications
• Shows readers how integration allows Access to get the benefit of Excel's flexible presentation layer and versatile analysis capabilities, while Excel gets the benefit of Access's relational database structure and robust querying tools

Table of contents:

Acknowledgements.

Introduction.

1. Getting Excel Data into Access.

2. Analyzing Excel Data with Access Queries.

3. Sprucing Up Excel Data with Access Reports.

4. Using Pivot Tables and Pivot Charts in Access.

5. Getting Access Data into Excel.

6. Leveraging Macros in Excel and Access.

7. VBA Fundamentals.

8. Using VBA to Move Data Between Excel and Access.

9. Exploring Excel and Access Automation.

10. Integrating Excel and Access with XML.

11. Integrating with Office Applications.

Index.