| Since Office XP, Microsoft has marketed the Office suite as a set of interoperable applications that allow for easy collaboration and integration of processes. Unfortunately the vast majority of users still look at the Office suite of applications as individual applications that are neatly partitioned by functionality. There are a lot of titles on the shelves that are dedicated to one application, often providing very little information on the concept of integration. The two applications that provide the most bang for the integration buck are Excel and Access. While both of these applications are powerful tools on there own, combining the functionality of Excel and Access opens up a whole new world of possibilities. Through integration, Access gets the benefit of Excel’s flexible presentation layer and versatile analysis capabilities; Excel gets the benefit of Access’ relational database structure and robust querying tools.
This book will show readers how combining the utility of these two Office powerhouses can help them save time and enhance their data analysis and reporting capabilities. In addition, this book will provide a few chapters on the integration of other office applications: Outlook, Word, and PowerPoint. Note: In order to maximize the target audience, this book will cover Office 2002, 2003, and 2007. Approach: This book offers a comprehensive review of the wide range of integration techniques that can be performed using Excel and Access. Along with step-by-step instruction, the book provides practical, real world, scenarios that show the benefits of integrating Excel and Access. It shows how to avoid common pitfalls while mo
|
