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
Lotus Notes and Domino 6 Development (2nd Edition)
Archiving Versions with Templates
Using View Column Properties
Working with the Page Properties Box
Working in the Agent Builder Design Window
Hyperlink Tags
VBScript Programmers Reference
Error Handling and Debugging
Classes in VBScript (Writing Your Own COM Objects)
Remote Scripting
Appendix C Coding Convention
Appendix D Visual Basic Constants Supported in VBScript
Snort Cookbook
Building a Distributed IDS (Encrypted)
Logging in Binary
Detecting Fragmentation Attacks and Fragment Reassembly with Frag2
Writing Output Plug-ins
Working with Honeypots and Honeynets
Network Security Architectures
Everything Is a Weapon
IPsec Modes of Operation and Security Options
Edge Security Design
Network Design Considerations
Data Structures and Algorithms in Java
Interfaces
The Java Collections Framework: A First Look
Projects
String Matching
C.1. Sum Notation
Programming .Net Windows Applications
Apply Button
Mouse Events
The Analog Clock Project
Debugging in Visual Studio .NET
Assemblies
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