The Excel analyst's guide to Access
The ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions. Sales...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Wiley Pub., Inc
2010.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627966506719 |
Tabla de Contenidos:
- The Excel® Analyst's Guide to Access®; About the Author; Contents at a Glance; Contents; Introduction; Part I: Fundamentals of Data Analysis in Access; Chapter 1: The Case for Data Analysis in Access; Chapter 2: Access Basics; Chapter 3: Beyond Select Queries; Part II: Basic Analysis Techniques; Chapter 4: Transforming Your Data with Access; Chapter 5: Working with Calculations and Dates; Chapter 6: Performing Conditional Analysis; Part III: Advanced Analysis Techniques; Chapter 7: Adding Dimension with Subqueries and Domain Aggregate Functions
- Chapter 8: Running Descriptive Statistics in AccessChapter 9: Scheduling and Running Batch Analysis; Chapter 10: Leveraging VBA to Enhance Data Analysis; Part IV: Reports, Dashboards, and Visualization in Access; Chapter 11: Presenting Data with Access Reports; Chapter 12: Using Pivot Tables and Pivot Charts in Access; Chapter 13: Enhancing Queries and Reports with Visualizations; Part V: Advanced Excel and Access Integration Techniques; Chapter 14: Getting Access Data into Excel; Chapter 15: Using VBA to Move Data between Excel and Access; Chapter 16: Exploring Excel and Access Automation
- Chapter 17: Integrating Excel and Access with XMLChapter 18: Integrating Excel and Other Office Applications; Part VI: Appendixes; Appendix A: Access VBA Fundamentals; Appendix B: Understanding and Using SQL; Appendix C: Query Performance, Database Corruption, and Other Thoughts; Appendix D: Data Analyst's Function Reference; Index
