Microsoft Excel and Access Integration : With Microsoft Office 2007

This book has some great tips on how to get these two programs to work together for even more sophistication and productivity. Excel is one of those programs where the average user uses perhaps 15 percent of its capabilities. The same is probably true of Access. Alexander and Clark show some great ways to get the programs to work together. Even as a seasoned user, I found some neat sections that opened my eyes. For me the best sections were those on Microsoft Query, getting Excel reports to look professional (by feeding them to Access Reports), the introduction to VBA, and the very clever sections on integration with Word and PowerPoint. This book will be a valuable addition to every Excel and Access user's bookshelf (and it won't get dusty there, I regularly use it as a reference).

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 At Www.wiley.com/go/exceland Accessintegration.

"Excel users. Access users. You're probably among the majority, living in one camp of 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 answer. [Features:] 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 process with VBA ; simplify integration tasks using XML ; integrate Excel data into other Office applications."--Page 4 of cover 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. Getting Excel data into Access Analyzing Excel data with Access queries Sprucing up Excel data with Access rep Using pivot tables and pivot charts in Access Getting Access data into Excel Leveraging macros in Excel and Access VBA fundamentals Using VBA to move data between Excel and Access Exploring Excel and Access automation Integrating Excel and Access with XML Integrating with office applications. 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