What to Expect from This Book
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. After reading this book, you will be able to:
■ Easily move data between Excel and Access
■ Store Excel data in a structured, relational database
■ Use Excel pivot tables with Access data
■ Report Access data using the Excel presentation layer
■ Move data between Excel and Access using VBA, ADO and SQL
■ Automate redundant processes using VBA to save time and increase productivity
■ Simplify integration tasks using XML
■ Integrate Excel data into other Office applications
Skills Required for This Book
In order to get the most out of this book, you have the following skills:
■ Some experience working with data and familiarity with the basic concepts of data analysis such as working with tables, aggregating data, and performing calculations.
■ Experience using Excel with a strong grasp of concepts such as table structures, filtering, sorting and using formulas.
■ Some basic knowledge of Access, enough to know it exists and to have opened a database once or twice
How This Book Is Organized
This book is organized into two parts: Basic Integration Techniques and Advanced Integration Techniques.
Part I: Basic Integration Techniques
Part I of this book is dedicated to those integration techniques that can be accomplished via the Excel and Access user interfaces. This part includes Chapters 1 through 6. Chapters 1 through 4 will teach you how to get your Excel data into Access as well as how to leverage the many Access utilities to go beyond the functionality found in Excel. Chapter 5 demonstrates the best ways to use Access data in Excel. Chapter 6 introduces you to the world of macros, demonstrating automation techniques from both an Excel and Access point of view.
Part II: Advanced Integration Techniques
Part II of this book is dedicated to automating your integration processes via VBA (Visual Basic for Applications) code. Chapter 7 provides a high level introduction to VBA. Chapter 8 covers the various methods of moving data between Excel and Access using VBA. In Chapter 9, you will learn how to control and manipulate Excel from Access and vice versa. Chapter 10 introduces you to the world of XML; discussing several ways XML can help you simplify your integration tasks. Finally, Chapter 11 rounds out this book with a look into the various ways you can integrate Excel with Word, PowerPoint and Outlook.
Download
http://rapidshare.com/files/139624820/Wiley.Microsoft.Excel.and.Access.Integration.With.Microsoft.Office.2007.Apr.2007.eBook-DDU.pdf
or
http://tinyurl.com/6y4tzk
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. After reading this book, you will be able to:
■ Easily move data between Excel and Access
■ Store Excel data in a structured, relational database
■ Use Excel pivot tables with Access data
■ Report Access data using the Excel presentation layer
■ Move data between Excel and Access using VBA, ADO and SQL
■ Automate redundant processes using VBA to save time and increase productivity
■ Simplify integration tasks using XML
■ Integrate Excel data into other Office applications
Skills Required for This Book
In order to get the most out of this book, you have the following skills:
■ Some experience working with data and familiarity with the basic concepts of data analysis such as working with tables, aggregating data, and performing calculations.
■ Experience using Excel with a strong grasp of concepts such as table structures, filtering, sorting and using formulas.
■ Some basic knowledge of Access, enough to know it exists and to have opened a database once or twice
How This Book Is Organized
This book is organized into two parts: Basic Integration Techniques and Advanced Integration Techniques.
Part I: Basic Integration Techniques
Part I of this book is dedicated to those integration techniques that can be accomplished via the Excel and Access user interfaces. This part includes Chapters 1 through 6. Chapters 1 through 4 will teach you how to get your Excel data into Access as well as how to leverage the many Access utilities to go beyond the functionality found in Excel. Chapter 5 demonstrates the best ways to use Access data in Excel. Chapter 6 introduces you to the world of macros, demonstrating automation techniques from both an Excel and Access point of view.
Part II: Advanced Integration Techniques
Part II of this book is dedicated to automating your integration processes via VBA (Visual Basic for Applications) code. Chapter 7 provides a high level introduction to VBA. Chapter 8 covers the various methods of moving data between Excel and Access using VBA. In Chapter 9, you will learn how to control and manipulate Excel from Access and vice versa. Chapter 10 introduces you to the world of XML; discussing several ways XML can help you simplify your integration tasks. Finally, Chapter 11 rounds out this book with a look into the various ways you can integrate Excel with Word, PowerPoint and Outlook.
Download
http://rapidshare.com/files/139624820/Wiley.Microsoft.Excel.and.Access.Integration.With.Microsoft.Office.2007.Apr.2007.eBook-DDU.pdf
or
http://tinyurl.com/6y4tzk
0 comments:
Post a Comment