Microsoft Access 2007 Data Analysis and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $39.99
  • Save: $12.04 (30%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
FREE Shipping on orders over $35.
Used: Good | Details
Sold by RentU
Condition: Used: Good
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft Access 2007 Data Analysis Paperback – March 9, 2007

ISBN-13: 978-0470104859 ISBN-10: 0470104856 Edition: 1st

Buy New
Price: $27.95
28 New from $21.02 30 Used from $3.40
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$27.95
$21.02 $3.40
12%20Days%20of%20Deals%20in%20Books

Frequently Bought Together

Microsoft Access 2007 Data Analysis + Excel 2007 Advanced Report Development + Microsoft Excel and Access Integration: With Microsoft Office 2007
Price for all three: $90.64

Buy the selected items together
NO_CONTENT_IN_FEATURE

Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

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

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.

More About the Author

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

Customer Reviews

Has good examples that are easy to understand.
Jacob Holmsgaard Fischer
It's refreshing to see a book about data-crunching with Access (instead of how to create a "contact database" or something like that).
JC Carlisle
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

Most Helpful Customer Reviews

28 of 28 people found the following review helpful By Truitt L. Bradly on April 21, 2007
Format: 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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
13 of 15 people found the following review helpful By JC Carlisle on May 16, 2007
Format: 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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 10 people found the following review helpful By Jonathan C. Anthony on April 22, 2008
Format: 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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 10 people found the following review helpful By Thomas G. McDowell on August 17, 2010
Format: Paperback Verified Purchase
This is a very good book for doing exactly what the title says. Easy to follow and there are a lot of useful tips on how to design queries and perform solid data analysis using Access. This is not a beginners book on how to use Access but a good learning tool once a few Access fundamentals have been learned elsewhere.

The Kindle edition has problems. Many of the screen shots of the actual examples (in particular of the query builder) are not readable on the kindle (and aren't readable on the kindle for PC), unfortunately for many of the sections this renders the information useless since it means you can't actually read the instructions for what is being demonstrated.

The hardcopy book is a 5 the Kindle version a 1 or 2. Hopefully the Kindle version can be reformatted and redistributed.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By Theresa Becker on January 20, 2008
Format: Paperback
I purchased this book as a textbook for an Access class I am taking. It is a very good source to help with the class. I especially like to be able to go to the site listed on the book and work with the data on line. This helps me to practice the different tasks the book is teaching. I recomend this to anyone who is learning Access.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 11 people found the following review helpful By M. Haslip on August 10, 2008
Format: Paperback
I just ordered Microsft Access 2007 Data Analysis, and paid the extra $ to use the "Amazon Online Reader" option.
Upside: as promised, I am able to immediately view the entire book using the Online Reader :-). The material seems excellent and I'm anxious to start working with the solutions the author is trying to provide me, but . . .
Downside: the Online Reader image quality is fuzzy, and renders the small font images and screen captures in the book illegible :-( Tres' aggravating since the details of the solutions are spelled out in text that I Just Can't Quite Read. I'm chomping at the byte for the postman to bring my hard copy!
I have emailed a query to Amazon's customer service folks, asking if there is a user-end fix for this dilemna. But, unless they have a solution, I would have to opin that the book itself appears well written and informative, but the Online Reader Option for this and other manuals with graphics needs refinement before I spend any more money on the service.
PS - Yes, the OnLine Reader problem is not limited to this book. A second book, different author, different publisher, which I purchased on-line Amazon Digital rights to at the same time is also fuzzy at best and the small type is not legible. //
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Shelly Jack on May 2, 2014
Format: Paperback Verified Purchase
Adds some additional tips and ideas for those of us who already know a great deal about access. Very informational
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


What Other Items Do Customers Buy After Viewing This Item?