Microsoft Access
2007 Data
Analysis
This
is
the
2007
version
of
the
best
selling
book
on
data
analysis
with
Microsoft
Access.
This book
shows
readers
that
Access
2007
has
strong
data
analysis
capabilities
that
are
easy
to
learn,
applicable
to
all
kinds
of
business
situations,
and
relevant
to
many
types
of
organizations. Practical
examples
show
the
benefits
of
using
Access
for
data
analysis,
as
well
as
the
common
pitfalls
of
every
day
data
crunching.
-
Chapter 1: The Case for Data Analysis in Access
-
Chapter 2: Access Basics
-
Chapter 3: Beyond Select Queries
-
Chapter 4: Transforming your Data in Access
-
Chapter 5: Working with Calculations and Dates
-
Chapter 6: Performing Conditional Analysis
-
Chapter 7: Understanding and Using SQL
-
Chapter 8: Subqueries and Domain Aggregate Functions
-
Chapter 9: Running Descriptive Statistics in Access
-
Chapter 10: Analyzing Date with Pivot Tables and Pivot Charts
-
Chapter 11: Scheduling and Running Batch Analysis
-
Chapter 12: Leveraging VBA to Enhance Data Analysis
-
Chapter 13: 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
Note
for
those
of
you
who
own
the
previous
version
of
this
book:
Outside
of
some
new
security
requirements,
data
analysis
in
Access
has
not
been
substantially
impacted
in
Access
2007.
