Microsoft
Access
Data
Analysis
While
there
are
lots
of
books
that
focus
on
Data
Analysis
with
Excel,
it
is
extremely
difficult
to
find
any
books
dedicated
to
Data
Analysis
with
Microsoft
Access.
I
wanted
to
write
a
book
that
shows
readers
that
Access
has
strong
data
analysis
capabilities
that
are
easy
to
learn,
applicable
to
all
kinds
of
business
situations,
and
relevant
to
many
types
of
organizations. Along
with
step-by-step
instruction
on
the
analytical
functionality
of
Access,
I
provide
practical,
real
world
scenarios
that
show
the
benefits
of
using
Access
for
data
analysis.
I
show
how
to
avoid
common
pitfalls
of
every
day
data
crunching,
and
I
routinely
discuss
how
Access
differs
from
Excel
when
covering
a
subject.
-
Chapter 1: Access Basics
-
Chapter 2: Beyond Select Queries
-
Chapter 3: Transforming your Data in Access
-
Chapter 4: Working with Calculations and Dates
-
Chapter 5: Performing Conditional Analysis
-
Chapter 6: Adding Dimension with SubqueriesDomain Aggregate Functions
-
Chapter 7: Running Descriptive Statistics in Access
-
Chapter 8: Analyzing Date with Pivot Tables and Pivot Charts
-
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, Other Final Thoughts
-
Appendix A: Data Analyst’s Function Reference
-
Appendix B: VBA Fundamentals
-
Appendix C: Data Analyst’s Error Reference
