|
" Microsoft Access data analysis : "
Michael Alexander.
Document Type
|
:
|
BL
|
Record Number
|
:
|
995818
|
Doc. No
|
:
|
b750188
|
Main Entry
|
:
|
Alexander, Michael,1972-
|
Title & Author
|
:
|
Microsoft Access data analysis : : unleashing the analytical power of Access /\ Michael Alexander.
|
Publication Statement
|
:
|
Indianapolis :: Wiley,, ©2006.
|
Page. NO
|
:
|
xxxi, 515 pages :: illustrations ;; 24 cm
|
ISBN
|
:
|
076459978X
|
|
:
|
: 9780764599781
|
Notes
|
:
|
Includes index.
|
Contents
|
:
|
Ch. 1. Access basics -- Ch. 2. Beyond select queries -- Ch. 3. Transforming your data with Access -- Ch. 4. Working with calculations and dates -- Ch. 5. Performing conditional analysis -- Ch. 6. Working with subqueries and domain aggregate functions -- Ch. 7. Running descriptive statistics in Access -- Ch. 8. Analyzing data with pivot tables and pivot charts -- Ch. 9. Scheduling and running batch analysis -- Ch. 10. Leveraging VBA to enhance data analysis -- Ch. 11. Reporting your results using Excel automation -- Ch. 12. Query performance, database corruption, and other final thoughts.
|
Abstract
|
:
|
Go beyond Excel® with Access' 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, and leverage information from the field with real world scenarios. See examples from this book firsthand, in our companion web site. The site also includes templates and tools to get you started.
|
Subject
|
:
|
Database management.
|
Subject
|
:
|
Relational databases.
|
Subject
|
:
|
Database management.
|
Subject
|
:
|
Relational databases.
|
Subject
|
:
|
ACCESS (Programm)
|
Subject
|
:
|
Microsoft Access.
|
|
:
|
Microsoft Access.
|
Dewey Classification
|
:
|
005.75/65
|
LC Classification
|
:
|
QA76.9.D3A495 2006
|
NLM classification
|
:
|
ST 271 A06rvk
|
| |