Dear customers, please be informed that our shopping cart will be unavailable between August 21 and September 1, 2014, as we will be making some changes to serve you better. To minimise any possible delivery disruption, we encourage you to make your purchases before August 21. We appreciate your understanding and apologise for any inconvenience.

Print this page Share

Microsoft Excel and Access Integration: With Microsoft Office 2007

ISBN: 978-0-470-10488-0
408 pages
April 2007
Microsoft Excel and Access Integration: With Microsoft Office 2007 (0470104880) cover image
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.
See More


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.


See More
Michael Alexander is a Microsoft Certified Application Developer (MCAD). He has more than thirteen years of experience as a consultant and developer of office solutions for various companies, and is the author of several books. Geoffrey Clark as fourteen years of real-world experience building and implementing custom solutions for clients worldwide. Currently, he develops office applications to enable enterprise-wide metrics and change initiatives.
See More
After reading this book, students will be able to:
  • Easily move data between Excel and Access
  • Store Excel data in a structured relational database
  • Use Excel functions in Access
  • Use Excel pivottables with Access Data
  • Report Access Data using Excel’s presentation layer
  • Retrieve Data using ADO and SQL
  • Automate redundant processes using VBA to save time and increase productivity
  • Integrate Excel and Access data into other Office applications
See More
Download TitleSizeDownload
Sample file install 7.09 MB Click to Download
Sample files from book 17.46 MB Click to Download
Additional download materials for chapter 2 147.54 KB Click to Download
Additional download materials for chapter 5 7.15 MB Click to Download
See More
Buy Both and Save 25%!

Microsoft Excel and Access Integration: With Microsoft Office 2007 (US $39.99)

-and- Excel 2010 For Dummies Quick Reference (US $18.99)

Total List Price: US $58.98
Discounted Price: US $44.23 (Save: US $14.75)

Buy Both
Cannot be combined with any other offers. Learn more.
Back to Top