Record Display for the EPA National Library Catalog

RECORD NUMBER: 6 OF 9

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
Description Access URL
http://www.wiley.com/WileyCDA/WileyTitle/productCd-076459978X,descCd-tableOfContents.html
Publisher description http://catdir.loc.gov/catdir/enhancements/fy0623/2005028950-d.html
Contributor biographical information http://catdir.loc.gov/catdir/enhancements/fy0741/2005028950-b.html
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.