+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)


Microsoft Excel and Access Integration. With Microsoft Office 2007

  • ID: 2251213
  • Book
  • May 2007
  • 388 Pages
  • John Wiley and Sons Ltd
Excel users. Access users. You're probably among the majority, living in one camp or the other but rarely crossing between the two. Yet Microsoft 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 team work, you'll find that your team's productivity is the real winner.

- Move data easily between Excel and Access

Store Excel data in a structured relational database

Create Excel PivotTables with Access data

Report Access data using Excel's presentation layer

Use VBA, ADO, and SQL to move data from one application to the other

Save time and increase productivity by automating redundant processes with VBA

Simplify integration tasks using XML

Integrate Excel data into other Office applications

Companion Web site

Find all the examples from the book in the database located

Note: Product cover images may vary from those shown


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.

Note: Product cover images may vary from those shown
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.
Note: Product cover images may vary from those shown