What this book will highlight is that there are powerful functionalities in both Excel and Access that can help you go beyond the one dimensional world of either spreadsheet or database. This book will liberate you from the daily grind of routine data practices and help you to explore all the functionality that exists when Excel and Access are brought together. Although both of these applications are powerful tools on their own, combining the functionality of Excel and Access opens up a whole new world of possibilities
In this book, you will find a comprehensive review of the wide range of integration techniques that can be performed using Excel and Access. Through step-by-step instruction, you will explore the benefits of integrating Excel and Access, the differences and similarities between Excel and Access, and some of the common pitfalls of moving and analyzing data across applications.
TABLE OF CONTENT:
Chapter 01 - Getting Excel Data into Access
Chapter 02 - Analyzing Excel Data with Access Queries
Chapter 03 - Sprucing Up Excel Data with Access Reports
Chapter 04 - Using PivotTables and PivotCharts in Access
Chapter 05 - Getting Access Data into Excel
Chapter 06 - Leveraging Macros in Excel and Access
Chapter 07 - VBA Fundamentals
Chapter 08 - Using VBA to Move Data Between Excel and Access
Chapter 09 - Exploring Excel and Access Automation
Chapter 10 - Integrating Excel and Access with XML
Chapter 11 - Integrating Excel and Other Office Applications
No comments:
Post a Comment