Integrating Excel and Access - page 1
- 1
- 2
- Integrating Excel and Access
- Integrating Excel and Access
- Table of Contents
- Copyright
- Preface
- Who Should Read This Book
- What s in This Book
- Conventions in This Book
- References in VBA
- We d Like Your Feedback
- Safari Enabled
- Acknowledgments
- Chapter 1. Introduction to AccessExcel Integration
- 1.1. Communications Between Excel and Access
- 1.2. Automation Objects
- 1.3. ADO and DAO
- 1.4. Tackling Projects
- 1.5. Designing Applications
- 1.6. Next Steps
- Chapter 2. Using the Excel User Interface
- 2.1. Using External Data
- 2.2. Using Database Queries
- 2.3. Returning a PivotTable to Excel
- Figure 2-13. Microsoft Query screen
- 2.5. Keeping the Query Updated with VBA
- 2.6. Next Steps
- Chapter 3. Data Access from Excel VBA
- 3.1. Writing a Reusable Module for Data Access
- 3.2. Choosing Between ADO and DAO
- 3.3. CopyFromRecordset Versus Looping
- 3.4. Formatting Techniques
- 3.5. Formatting Techniques Example
- 3.6. Summary
- Chapter 4. Integration from the Access Interface
- 4.1. Importing Excel Data
- 4.2. Linking Excel Data
- 4.3. Using Export and Analyzing It with Microsoft Office Excel
- 4.4. Using Raw Exported Access Data in Excel
- 4.5. Exporting an Access Report to Excel
- 4.6. Next Steps
- Chapter 5. Using Access VBA to Automate Excel
- 5.1. High-Level Excel Objects
- 5.2. Other Excel Objects
- 5.3. Writing and Using Queries in VBA
- 5.4. Referencing Sheets, Ranges, and Cells
- 5.5. Writing Excel Worksheet Functions from Access VBA
- 5.6. Chapter Summary and Next Steps
- Chapter 6. Using Excel Charts and Pivot Tables with Access Data
- 6.1. Automating Pivot Tables
- 6.2. Building a Regular Chart
- 6.3. Using an Array Formula
- 6.4. Graphing Variables in a Model
- Chapter 7. Leveraging SQL Server Data with Microsoft Office
- 7.1. Pass-Through Queries Versus Linked Tables
- 7.2. Creating a Connection Using VBA
- 7.3. Building the Connection in Access
- 7.4. Pulling Data in with Excel Alone
- 7.5. Using DTS to Automate Excel
- 7.6. Crosstab Queries on SQL Server
- 7.7. SQL Server Summary
- Chapter 8. Advanced Excel Reporting Techniques
- 8.1. Writing Flexible Formulas
- 8.2. Changing Data in an Existing Report
- 8.3. Creating a Report from Scratch
- 8.4. Using an Access Table for Reporting
- 8.5. Putting It Together
- Chapter 9. Using Access and Excel Data in Other Applications
- 9.1. Automating Microsoft Word
- 9.2. Getting Information from Microsoft Word
- 9.3. Automating PowerPoint
- 9.4. Using Data in MapPoint
- 9.5. Summary
- Chapter 10. Creating Form Functionality in Excel
- 10.1. Working with the UserForm
- 10.2. Accepting Parameters
- 10.3. Other Useful Items
- 10.4. Next Steps
- Chapter 11. Building Graphical User Interfaces
- 11.1. Setting Up a Form
- 11.2. Using Events
- 1
- 2
