Wiley.com
Print this page Share

Microsoft Excel and Access Integration: With Microsoft Office 2007

Michael Alexander, Geoffrey Clark
ISBN: 978-0-470-10488-0
Paperback
388 pages
April 2007
Microsoft Excel and Access Integration: With Microsoft Office 2007 (0470104880) cover image
This title is out-of-print and not currently available for purchase from this site.

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

Related Titles

More By These Authors

Excel Dashboards and Reports
The Excel Analyst's Guide to Access
Excel 2007 Dashboards and Reports For Dummies
Microsoft Access 2007 Data Analysis
Excel 2007 VBA Programmer's Reference

Microsoft Excel

Beginning Excel Services
by Liviu Asnash, Eran Megiddo, Craig Thomas
Microsoft Office Excel 2007: The L Line
by Kathy Jacobs
Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables
by Denise Etheridge
Microsoft Office Excel 2007 Programming: Your visual blueprint for creating interactive spreadsheets
by Denise Etheridge
Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and presenting Excel data
by Paul McFedries
Back to Top