Flylib.com
Integrating Excel and Access
Integrating Excel and Access
ISBN: 0596009739
EAN: 2147483647
Year: 2005
Pages: 132
Authors:
Michael Schmalz
BUY ON AMAZON
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
11.3. Using Data
11.4. Adding Buttons
11.5. Tab Order
11.6. Next Steps
Chapter 12. Tackling an Integration Project
12.1. The Project Description
12.2. Main Menu
12.3. Customer Information
12.4. Billing and Payment Information
12.5. Contact History
12.6. Services and Charges
12.7. Expense Entry
12.8. Invoices
12.9. Letters
12.10. Income Statements
12.11. Project Summary
Appendix A. Excel Object Model
A.1. Application Object
A.2. Workbook and Worksheet Objects
A.3. Excel Object Model Summary
Appendix B. VBA Basics
B.1. Dim and Set Statements
B.2. Loops
B.3. With Statement
B.4. Goto Statement
B.5. Select Case Statement
B.6. If Statements
B.7. VBA Summary
About the Author
Colophon
Index
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_I
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
Integrating Excel and Access
ISBN: 0596009739
EAN: 2147483647
Year: 2005
Pages: 132
Authors:
Michael Schmalz
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
Schedule Planning
Other Planning Processes
Comprehensive Project Plan
Project Control
Project Closure
Software Configuration Management
Configuration Change Management
Appendix A Project Plan
Appendix E Test Plan
Appendix S Sample Maintenance Plan
Appendix W Physical Configuration Audit (PCA) Checklist
The CISSP and CAP Prep Guide: Platinum Edition
Information Security and Risk Management
Operations Security
The Accreditation Phase
Continuous Monitoring Process
Appendix D The Information System Security Engineering Professional (ISSEP) Certification
The Java Tutorial: A Short Course on the Basics, 4th Edition
Code Samples
Code Samples
Using the Timer and TimerTask Classes
Overview of I/O Streams
Example Three: CelsiusConverter
Microsoft VBScript Professional Projects
What Is VBScript?
VBScript and Internet Explorer
Using Configuration Files to Control Script Execution
Maintaining a 30-Day Summary Log Archive
Processing and Consolidating Report Data
Java All-In-One Desk Reference For Dummies
Java Programming Basics
Adding Some Methods to Your Madness
Handling Exceptions
Using Regular Expressions
Creating Servlets
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies