Microsoft Excel and Access Integration
With Microsoft Office 2007
By Michael Alexander, Geoffrey Clark
Publisher: Wiley
Final Release Date: July 2007
Pages: 400

Excel users. Access users. You're probably among the majority,living in one camp or the other but rarely crossing between thetwo. Yet Microsoft designed these applications to work together. Inthis book, you'll discover how Access benefits from Excel'sflexible presentation layer and versatile analysis capabilities,while Access's relational database structure and robust queryingtools enhance Excel. Once you learn to make the team work, you'llfind 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 theother

  • Save time and increase productivity by automating redundantprocesses 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 atwww.wiley.com/go/exceland accessintegration.

Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $39.99
Formats:  ePub, Mobi, PDF