Integrating Excel and Access
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage....
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2005.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627098506719 |
Tabla de Contenidos:
- Integrating Excel and Access; What&s in This Book; Conventions in This Book; References in VBA; We&d Like Your Feedback!; Safari Enabled; Acknowledgments; 1. Introduction to Access/Excel Integration; 1.2. Automation Objects; 1.3. ADO and DAO; 1.4. Tackling Projects; 1.5. Designing Applications; 1.6. Next Steps; 2. Using the Excel User Interface; 2.2. Using Database Queries; 2.3. Returning a PivotTable to Excel; 2.4. Using Microsoft Query to Gather Data; 2.5. Keeping the Query Updated with VBA; 2.6. Next Steps; 3. Data Access from Excel VBA; 3.2. Choosing Between ADO and DAO
- 3.3. CopyFromRecordset Versus Looping3.4. Formatting Techniques; 3.5. Formatting Techniques Example; 3.6. Summary; 4. Integration from the Access Interface; 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; 5. Using Access VBA to Automate Excel; 5.1.2. The Workbook Object; 5.1.3. The Worksheet Object; 5.2. Other Excel Objects; 5.2.2. The Cells Property; 5.2.3. Using Offset; 5.3. Writing and Using Queries in VBA; 5.3.2. Querying Data with Form Input
- 5.3.3. Creating Crosstab Queries5.3.4. Generating a Created Crosstab Query; 5.4. Referencing Sheets, Ranges, and Cells; 5.4.2. Working with Ranges; 5.4.3. Working with Cells; 5.5. Writing Excel Worksheet Functions from Access VBA; 5.6. Chapter Summary and Next Steps; 6. Using Excel Charts and Pivot Tables with Access Data; 6.2. Building a Regular Chart; 6.3. Using an Array Formula; 6.4. Graphing Variables in a Model; 7. Leveraging SQL Server Data with Microsoft Office; 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 Excel7.6. Crosstab Queries on SQL Server; 7.7. SQL Server Summary; 8. Advanced Excel Reporting Techniques; 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; 9. Using Access and Excel Data in Other Applications; 9.2. Getting Information from Microsoft Word; 9.3. Automating PowerPoint; 9.4. Using Data in MapPoint; 9.5. Summary; 10. Creating Form Functionality in Excel; 10.2. Accepting Parameters; 10.3. Other Useful Items; 10.4. Next Steps
- 11. Building Graphical User Interfaces11.2. Using Events; 11.2.2. BeforeUpdate/AfterUpdate; 11.2.3. OnChange; 11.2.4. OnDirty; 11.2.5. OnEnter/OnExit; 11.2.6. OnClick/OnDoubleClick; 11.2.7. OnOpen; 11.2.8. OnTimer; 11.3. Using Data; 11.4. Adding Buttons; 11.5. Tab Order; 11.6. Next Steps; 12. Tackling an Integration Project; 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; A. Excel Object Model
- A.1.1.2. ActiveChart
