Main Title |
Microsoft Access data analysis : unleashing the analytical power of Access / |
Author |
Alexander, Michael,
|
Publisher |
Wiley, |
Year Published |
2006 |
OCLC Number |
61879674 |
ISBN |
076459978X (paper/website); 9780764599781 |
Subjects |
Database management ;
Relational databases ;
ACCESS (Programm)
|
Internet Access |
|
Holdings |
Library |
Call Number |
Additional Info |
Location |
Last Modified |
Checkout Status |
EJAM |
QA76.9.D3A495 2006 |
|
Region 3 Library/Philadelphia, PA |
03/26/2012 |
DISPERSAL |
|
Collation |
xxxi, 515 p. : ill. ; 24 cm. |
Notes |
Includes index. |
Contents Notes |
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. 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. |
Place Published |
Indianapolis |
PUB Date Free Form |
c2006 |
BIB Level |
m |
Cataloging Source |
OCLC/T |
LCCN |
2005028950 |
Merged OCLC records |
62225578 |
OCLC Time Stamp |
20120321110117 |
Language |
eng |
Origin |
OCLC |
Type |
CAT |
OCLC Rec Leader |
03201cam 22005654a 45020 |