Microsoft Access 2007 Data Analysis [Paperback]

Michael Alexander (Author)

Book Description

Publication Date: March 26, 2007 | ISBN-10: 0470104856 | ISBN-13: 978-0470104859 | Edition: 1

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.

Editorial Reviews

From the Back Cover

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

About the Author

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than thirteen years of experience consulting and developing office solutions. He currently serves as the director of an analytical services department for a $700 million company. He also runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.

Product Details

• Paperback: 552 pages
• Publisher: Wiley; 1 edition (March 26, 2007)
• Language: English
• ISBN-10: 0470104856
• ISBN-13: 978-0470104859
• Product Dimensions: 9.2 x 7.4 x 1.2 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #285,699 in Books (See Top 100 in Books)

More About the Author

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of 8 books on advanced business analysis with Microsoft Access and Excel. He has more than 14 years experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community.

Customer Reviews

Most Helpful Customer Reviews

26 of 26 people found the following review helpful:

4.0 out of 5 stars Great resource for learning how to use Access to analyse your data., April 21, 2007

By 

Truitt L. Bradly "Microsoft Access MVP 2007 &... (Austin, TX) - See all my reviews
(REAL NAME)   

This review is from: Microsoft Access 2007 Data Analysis (Paperback)

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

11 of 13 people found the following review helpful:

5.0 out of 5 stars Finally a book on analysis with Access, May 16, 2007

By 

JC Carlisle "Jim" (RTP, North Carolina) - See all my reviews

This review is from: Microsoft Access 2007 Data Analysis (Paperback)

It's refreshing to see a book about data-crunching with Access (instead of how to create a "contact database" or something like that). Clearly written with concrete examples.

8 of 9 people found the following review helpful:

5.0 out of 5 stars Advanced Skills in Access, April 22, 2008

By 

Jonathan C. Anthony - See all my reviews
(REAL NAME)   

This review is from: Microsoft Access 2007 Data Analysis (Paperback)

This is an excellent text, it was used in my CIS 2640 Business Reports and Analysis class at Western Michigan University in the Spring of 2008. I learned a great deal about building tables and queries in Access, a tool that will come in handy in almost any business related work. It's user friendly, and I feel is a good price for what it offers, and is designed from a beginner to someone who is experienced in Office 2003, looking to update their skills.