BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need
Stock photo: cover may vary

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need Paperback - 2007 - 1st Edition

by Ken Bluttman; Wayne S. Freeze

Add to wish list

Offering a collection of practical ways to use Access to analyze data and then present the analysis, the first part of the book shows how to extract data while the second shows how to perform calculations on it.

Reader reviews for Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need

Write a review for this book

There are no reviews for this book yet. Be the first to write a review!

Your review will be anonymous unless you login or create an account first.

Overall rating
Remember: You’re rating the book as a work, not the seller or the condition of the specific copy you purchased!

Important Terms and Guidelines

  • Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
  • Reviews must be at least 140 characters in length.
  • Please do not reveal critical plot elements.
  • This is not a help line. Contact customer support if you need help.
Your review must not include:
  • Obscenities, discriminatory language, or other insulting language not suitable for public domain
  • Advertisements, “spam” content, or references to other products, offers or websites.
  • Email addresses, URLs, phone numbers, physical addresses or other contact information.
  • Overly critical comments about other reviews or reviewers
  • Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
  • Availability, price, or alternative ordering/shipping information

From the publisher

If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.

Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to:
  • Develop basic and sophisticated queries
  • Apply aggregate functions, custom functions, regular expressions, and crosstabs
  • Apply queries to perform non-passive activities such as inserting, updating, and deleting data
  • Create and manipulate tables and queries programmatically
  • Manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text
  • Use arrays, read and write to the Windows registry, encrypt data, and use transaction processing
  • Use the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products
  • Find answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculations
  • Deal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (ROI)
  • Explore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutations
Access Data Analysis Cookbook is a one-stop-shop for extracting nuggets of valuable information from your database, and anyone with Access experience will benefit from these tips and techniques, including seasoned developers. If you want to use your data, and not just store it, you'll find this guide indispensable.

Details

  • Title Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need
  • Author Ken Bluttman; Wayne S. Freeze
  • Binding Paperback
  • Edition number 1st
  • Edition 1
  • Pages 366
  • Volumes 1
  • Language ENG
  • Publisher O'Reilly Media
  • Publication date 2007-06-19
  • Illustrated Yes
  • Features Illustrated, Index, Price on Product - Canadian, Table of Contents
  • ISBN 9780596101220 / 0596101228
  • Weight 1.26 lbs (0.57 kg)
  • Dimensions 9.16 x 7.1 x 0.89 in (23.27 x 18.03 x 2.26 cm)
  • Category Computers - Data Base Management
  • Library of Congress subjects Statistics - Data processing, Database searching
  • Dewey Decimal Code 005.756

Media reviews

Citations

  • Scitech Book News, 12/01/2008, Page 28

About the author

Ken Bluttman is the author of numerous computer books and articles. He recently wrote O'Reilly's "Access Hacks" as well as "Excel Charts for Dummies". Ken's technical chops include Microsoft Office, XML, VBA, VB.NET, SQL Server, and assorted web technologies.

Wayne S. Freeze is the Head of Software Development for Electrical Controls, Inc., where he builds software 3D graphics applications using Visual Basic, SQL Server and DirectX. He has written more than a dozen books over the years and has over seventy-five articles to his credit. Wayne has been using and writing about Access for nearly ten years, and has over 30 years of experience using all types of computers, from small, embedded microprocessor control systems to large-scale IBM mainframes. He also has a master's degree in management information systems as well as degrees in computer science and electrical engineering.

Back to top↑

More Copies for Sale

Show all copies
Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need (Cookbooks Ser.)

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need (Cookbooks Ser.)

by Freeze, Wayne S

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
World of Books Ltd
Item price
A$5.33
A$16.37 Delivery to USA

Show details

Description:
Paperback. Good.
Add to wish list
Item price
A$5.33
A$16.37 Delivery to USA
Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need (Cookbooks Ser.)

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need (Cookbooks Ser.)

by Freeze, Wayne S

  • Used
  • Very good
  • Paperback
Condition
Very good
Binding
Paperback
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
World of Books Ltd
Item price
A$5.33
A$16.37 Delivery to USA

Show details

Description:
Paperback. Very Good.
Add to wish list
Item price
A$5.33
A$16.37 Delivery to USA
Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need
Stock photo: cover may vary

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need

by Bluttman, Ken

  • Used
Condition
Used
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
Phatpocket Limited
Item price
A$6.21
A$17.09 Delivery to USA

Show details

Description:
O'Reilly Media. Used - Good. Ships from UK in 48 hours or less (usually same day). Your purchase helps support Sri Lankan Children's Charity 'The Rainbow Centre'. Ex-library, so some stamps and wear, but in good overall condition. 100% money back guarantee. We are a world class secondhand bookstore based in Hertfordshire, United Kingdom and specialize in high quality textbooks across an enormous variety of subjects. We aim to provide a vast range of textbooks, rare and collectible books at a great price. Our donations to The Rainbow Centre have helped provide an education and a safe haven to hundreds of children who live in appalling conditions. We provide a 100% money back guarantee and are dedicated to providing our customers with the highest standards of service in the bookselling industry.
Add to wish list
Item price
A$6.21
A$17.09 Delivery to USA
Access Data Analysis Cookbook : Slicing and Dicing to Find the Results You Need
Stock photo: cover may vary

Access Data Analysis Cookbook : Slicing and Dicing to Find the Results You Need

by Freeze, Wayne S., Bluttman, Ken

  • Used
Condition
Used
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
Better World Books Ltd
Biblio Top Seller
Item price
A$10.07
A$9.93 Delivery to USA

Show details

Description:
O'Reilly Media, Incorporated. Used - Very Good. Former library copy. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.
Add to wish list
Item price
A$10.07
A$9.93 Delivery to USA
Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need
Stock photo: cover may vary

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need

by Bluttman, Ken; Freeze, Wayne

  • Used
  • Acceptable
  • first
Condition
Acceptable
Edition
1
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
2
Seller
BooksRun
Item price
A$10.83
Free Delivery to USA

Show details

Description:
O'Reilly Media. 1. Acceptable. The item might be beaten up but readable. May contain markings or highlighting, as well as stains, bent corners, or any other major defect, but the text is not obscured in any way.
Add to wish list
Item price
A$10.83
Free Delivery to USA
Access Data Analysis Cookbook : Slicing and Dicing to Find the Results You Need

Access Data Analysis Cookbook : Slicing and Dicing to Find the Results You Need

by Ken Bluttman; Wayne S. Freeze

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
ThriftBooks
Biblio Top Seller
Item price
A$14.01
Free Delivery to USA

Show details

Description:
O'Reilly Media, Incorporated, 2007. Paperback. Good. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Add to wish list
Item price
A$14.01
Free Delivery to USA
Access Data Analysis Cookbook : Slicing and Dicing to Find the Results You Need
Stock photo: cover may vary

Access Data Analysis Cookbook : Slicing and Dicing to Find the Results You Need

by Freeze, Wayne S., Bluttman, Ken

  • Used
Condition
Used
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
Better World Books
Biblio Top Seller
Item price
A$17.98
Free Delivery to USA

Show details

Description:
O'Reilly Media, Incorporated. Used - Very Good. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.
Add to wish list
Item price
A$17.98
Free Delivery to USA
Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need
Stock photo: cover may vary

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need

by Bluttman, Ken

  • Used
  • Paperback
  • first
Condition
Used
Edition
1
Binding
Paperback
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
Ergodebooks
Item price
A$19.37
Free Delivery to USA

Show details

Description:
O'Reilly, 2007-06-19. 1. paperback. Used: Good. 7.00x0.89x9.19. Buy with confidence. Excellent Customer Service & Return policy.
Add to wish list
Item price
A$19.37
Free Delivery to USA
Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need
Stock photo: cover may vary

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need

by Freeze, Wayne S.,Bluttman, Ken

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
1
Seller
Pink Terrace
Item price
A$42.09
A$6.79 Delivery to USA

Show details

Description:
O'Reilly Media, 2007-05-29. Paperback. New. 0.9000 in x 9.0000 in x 7.0000 in.
Add to wish list
Item price
A$42.09
A$6.79 Delivery to USA
Access Data Analysis Cookbook
Stock photo: cover may vary

Access Data Analysis Cookbook

by Bluttman, Ken Freeze, Wayne S,

  • New
Condition
New
ISBN 10 / ISBN 13
9780596101220 / 0596101228
Quantity available
5
Seller
GreatBookPrices
Item price
A$43.72
A$5.66 Delivery to USA

Show details

Description:
new.
Add to wish list
Item price
A$43.72
A$5.66 Delivery to USA
Show all copies
Back to top↑

Please wait a moment while we load the requested page.