Binding: Paperback Dewey Decimal Number: 005.7565 EAN: 9780596101220 Format: Illustrated ISBN: 0596101228 Label: O'Reilly Media, Inc. Manufacturer: O'Reilly Media, Inc. Number Of Items: 1 Number Of Pages: 366 Publication Date: May 14, 2007 Publisher: O'Reilly Media, Inc. Sales Rank: 70811 Studio: O'Reilly Media, Inc.
Product DescriptionIf 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.
Customer Reviews
Average Rating:
Rating: - Great For Access Users!
The 'Access Data Analysis Cookbook' is a fantastic resource manual for anyone that needs to use Access on a daily basis to get the information they crave. Jammed with over 100 'recipes', you will learn how to write queries, export/import data, generate statistics, build/work with strings, and better manage your data.
I love this book. I have used Access for many years and feel that anyone that has to work with this simple, effective database at your job should pick up this great book, ... Read More
Rating: - Excellent book on Access as applied to business problems
This book is not about designing forms, primary keys, or the use of built-in wizards to make easy queries or reports. This book is about applying Access to real-world business problems. The book addresses how to query data, how to move data to and from Access in various ways, the calculation of different financial and investment terms, and other such problems. The reader of this book should already have some Access experience and thus know how to get around the Access user interface, know basic table ... Read More
Rating: - Great Book
This book is compatible for Access 2007 and 2003(title of book doesn't let you know that), what it does is answer questions that the author poses. Many of these scenarios are relevant. I have never bought an o'reilly cookbook previously, but this book is very refreshing especially when you look at the current books out there. This book isn't for new people, this book is for people who want real solutions to the problems that they might face. If your looking for a first book to get a real grasp of ... Read More
Rating: - Perfect for managers who already have the basics down.
Any involved in database management in general and Access in particular will want the ACCESS DATA ANALYSIS COOKBOOK, a survey which shows how to solve common problems of extracting data and performing calculations from large databases. From developing better queries and applying them to inserting, updating and deleting data to managing text-based data and using arrays, this offers a wealth of high-level technical Access information perfect for managers who already have the basics down.
Rating: - Great for when you know Excel and are new to Access
I am not sure if this was the intention of the authors, but I find this book to be amazingly helpful given my set of circumstances: I am pretty skilled in Excel and very new to Access, and I want to use Access in the same way I use Excel, but with much larger quantities of data. Of all the Access books I have been referencing, this one is by far the most useful. It provides lots of information on SQL if you are interested, but I'm ignoring that for now and still the book is great at providing the answers ... Read More
