There’s more than one way to crunch and present data. Although Excel dominates the landscape, Microsoft Access is widely available and is includes on all the Professional and Developer releases of Microsoft Office. Discover why many believe Access to be the better data analysis tool in this valuable guide from an industry expert.
With step-by-step instructions, tips for avoiding common pitfalls, and shortcuts for quickly slicing data into multiple views, this hands on book will soon have you using Access like a pro.
- Go beyond Excel 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
Part One Fundamentals of Data Analysis in Access
Part Two Basic Analysis Techniques
Part Three Advanced Analysis Techniques
Part Four Automating Data Analysis
Appendix A Data Analyst’s Function Reference
Appendix B Access VBA Fundamentals
Appendix C Data Analyst’s Error Reference