By Michael Alexander
552 pages
Publisher: Wiley (March 26, 2007)
ISBN-10: 0470104856
ISBN-13: 978-0470104859
Book Description
Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.
- Apply Access 2007 to the task of collecting, transforming, analyzing, and presenting data
Create custom functions, perform batch analysis, and develop automated procedures that essentially run themselves
Build effective query skills
Learn to clean and shape raw data, create and utilize custom calculations, work with dates, and perform advanced time analysis
Work with SQL statements, PivotTables, and PivotCharts
Perform advanced statistical analysis using subqueries and domain aggregate functions
See how to use macros and Visual Basic® for Applications to enhance data analysis
Download Microsoft Access 2007 Data Analysis
No comments:
Post a Comment