Microsoft Excel and Access Integration: With Microsoft Office 2007 (Google eBook)

Front Cover
John Wiley & Sons, Jun 12, 2012 - Computers - 408 pages
0 Reviews
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.
  

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Bringing Your Excel Data into Access
1-5
Summary
2-11
CHAPTER 2
2-12
Using Aggregate Queries
2-26
Using Calculations in Your Analysis
2-33
Leveraging Access Query Wizards to Solve Common Excel Problems
2-37
Summary
3-2
CHAPTER 3
3-3
The Visual Basic Editor or VBE
6-50
Variables
6-54
Procedures and Functions
6-56
VBA Coding Fundamentals
6-60
Getting Help with VBA
6-66
Summary
6-69
CHAPTER 8
6-71
Understanding SQL Fundamentals
6-79

Creating and Modifying Grouped Reports
3-12
Customizing Reports with Formatting
3-18
Creating an Individualized Customer Letter
3-45
Summary
4-11
CHAPTER 4
4-12
Working with PivotCharts in Access
4-33
Summary
4-44
CHAPTER 5
4-45
Introduction to Microsoft Query
5-9
Advanced Use of Microsoft Query
5-32
Limitations of Microsoft Query
5-42
Summary
5-43
CHAPTER 6
5-44
Introducing Excel Macros
5-46
Macros in Microsoft Access
6-25
Summary
6-44
CHAPTER 7
6-47
Common Scenarios Where VBA Can Help
6-89
Summary
6-96
CHAPTER 9
6-97
Automating Excel from Access
6-98
Automating Access from Excel
9-9
Summary
9-22
CHAPTER 10
9-23
Understanding XML
9-24
Creating a Simple Reporting Solution with XML
9-27
Creating a Data Entry Process Using XML
9-33
Summary
9-37
CHAPTER 11
9-39
Integrating Excel with PowerPoint
9-53
Integrating Excel and Outlook
9-62
Summary
9-71
Copyright

Common terms and phrases

About the author (2012)

Michael Alexander is a Microsoft Certified Application Developer (MCAD). He has more than thirteen years of experience as a consultant and developer of office solutions for various companies, and is the author of several books. Geoffrey Clark as fourteen years of real-world experience building and implementing custom solutions for clients worldwide. Currently, he develops office applications to enable enterprise-wide metrics and change initiatives.

Bibliographic information