|
 |
|
 |
 |
Microsoft Access 2007 Data Analysis
|
by Michael Alexander
Sales Rank: 69384
|
Discount: 34 %
List Price: $39.99
$26.39
At Amazon

|
|
Paperback: 552 pages
Publisher: Wiley March 26, 2007
Language: English
ISBN-10: 0470104856
ISBN-13: 978-0470104859
Product Dimensions:
9.2 x 7.2 x 1.3 inches
Shipping Weight: 1.6 pounds
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.
Back Cover Copy
Chart a course for more effective data analysis
Data analysis is more than crunching numbers and turning them into charts and graphs. Certainly Excel can do that, but you may be surprised to discover that Access 2007 offers powerful functionality that may be even 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
Companion web site
Find all the examples from the book in the sample database located at www.wiley.com/go/access2007dataanalysis
Customer Reviews & Comments
While most Access books focus on designing forms and reports, this book goes straight to the basics of analyzing data. After a short review of table design, the author quickly gets to the heart of data analysis by showing how to construct queries by using Access's graphical interface and illustrating how to write your own SQL. Advanced query techniques using subqueries and domain aggregate functions are fully described. The author demonstrates how to create pivot tables and charts from within Access and how to use Visual Basic for Applications to increase the power of your application. I recommend this book for beginning and intermediate users of Access who need to learn how to use Access to analyze data. Truitt L. Bradly Senior Actuarial Analyst Microsoft Office - Access - Most Valuable Professional 2007
Comment | Permalink |
(Report this)
|
Microsoft Access 2007 Data Analysis
List Price: $39.99
Discount: 34 %
Available from Amazon
Price: $26.39

| |
|
|
|
|