Microsoft Access Data Analysis

Unleashing the Analytical Power of Access

Michael Alexander

552 pages, parution le 01/02/2006

Ajouter à une liste

Indisponible

Résumé

Go beyond Excel(r) with Access's more powerful analysis capabilities
Get better visibility into your data with custom views
Scale up your data pool without limitation
Master the four fundamentals of data analysis
Discover shortcuts with the helpful Input Mask Wizard
Integrate your data with the web and enterprise data sources
Avoid the common pitfalls of data crunching
Harness VBA to improve data analysis
Leverage information from the field with real-world scenarios

Companion web site

See examples from this book firsthand, in our companion web site. The site also includes templates and tools to get you started.

L'auteur - Michael Alexander

Michael Alexander est développeur d'applications pour Microsoft. Il dispense également des conseils sur Excel et Access sur son site Web, www.datapigtechnologies.com.

Autres livres de Michael Alexander

Programmation VBA pour Excel 2019 pour les nuls

Découvrir tous les livres de Michael Alexander

Sommaire

Part One: Fundamentals of Data Analysis in Access
- Chapter 1: Access Basics
- Chapter 2: Beyond Select Queries
Part Two: Basic Analysis Techniques
- Chapter 3: Transforming Your Data with Access
- Chapter 4: Working with Calculations and Dates
- Chapter 5: Performing Conditional Analysis
Part Three: Advanced Analysis Techniques
- Chapter 6: Working with Subqueries and Domain Aggregate Functions
- Chapter 7: Running Descriptive Statistics in Access
- Chapter 8: Analyzing Data with Pivot Tables and Pivot Charts
Part Four: Automating Data Analysis
- Chapter 9: Scheduling and Running Batch Analysis
- Chapter 10: Leveraging VBA to Enhance Data Analysis
- Chapter 11: Reporting Your Results Using Excel Automation
- Chapter 12: Query Performance, Database Corruption, and Other Final Thoughts
- Appendix A: Data Analyst's Function Reference
- Appendix B: Access VBA Fundamentals
- Appendix C: Data Analyst's Error Reference

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Michael Alexander
Parution	01/02/2006
Nb. de pages	552
Format	19 x 23
Couverture	Broché
Poids	800g
Intérieur	Noir et Blanc
EAN13	9780764599781
ISBN13	978-0-7645-9978-1