* 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 at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Höhe: 23.3 cm
Breite: 18.7 cm
Dicke: 3 cm
Gewicht
ISBN-13
978-0-7645-9978-1 (9780764599781)
Schweitzer Klassifikation
Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than 13 years experience consulting and developing office solutions. Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White House's Military Office. He parlayed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries. He currently lives in Plano, TX where he serves as the director of an analytical services department of a $700 million company. In his spare time, he runs a free tutorial site, www.datapig technologies.com, where he shares basic Access and Excel tips with intermediate users.
PART I: FUNDAMENTALS OF DATA ANALYSIS IN ACCESS.
1. Access Basics.
2. Beyond Select Queries.
PART II: BASIC ANALYSIS TECHNIQUES.
3. Transforming Data with Access.
4. Working with Calculations and Dates.
5. Performing Conditional Analysis.
PART III: ADVANCED ANALYSIS TECHNIQUES.
6. Working with Subqueries and Domain Aggregate Functions.
7. Running Descriptive Statistics in Access.
8. Analyzing Data with Pivot Tables and Pivot Charts.
PART IV: AUTOMATING DATA ANALYSIS.
9. Scheduling and Running Batch Analysis.
10. Leveraging VBA to Enhance Data Analysis.
11. Reporting Your Results Using Excel Automation.
12. Query Performance, Database Corruption, and Other Final Thoughts.
Appendix A: Data Analyst's Function Reference.
Appendix B: VBA Fundamentals.
Appendix C: Data Analyst's Error Reference.
Index.