Slice and Dice Your Data to Find the Results You Need

Sebastopol, CA—If you have large quantities of data in a Microsoft Access database—and you need to study that data in depth—this book can be the answer to all that ails you. Access Data Analysis Cookbook (O'Reilly, US $49.99) by Ken Bluttman and Wayne S. Freeze is packed with practical recipes for solving the common problems you run into when extracting data and performing calculations. Each recipe offers step-by-step solutions, with a discussion on how and why the solutions work.

Fully up-to-date for Access 2007—and suitable for earlier versions—this book teaches 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 much more. You'll learn to apply statistics when summarizing business information, jump beyond SQL by manipulating data with VBA, process dates and times, and even reach into the Excel data analysis toolkit. These recipes will also teach you to:

• Develop basic and sophisticated queries
• Apply aggregate functions, custom functions, regular expressions, and crosstabs
• Apply queries to perform nonpassive activities, such as inserting, updating, and deleting data
• Create and manipulate tables and queries programmatically
• Manage text
• based data, isolate parts of a string, and work with numbers that are stored as text
• Use arrays, read and write to the Windows registry, encrypt data, and use transaction processing
• Operate FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products
• 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, and combinations and permutations

Want to do more with your data than simply store it? Access Data Analysis Cookbook is a one-stop shop for extracting nuggets of valuable information from your database.

For a review copy or more information please email . Please include your delivery address and contact information.

Ken Bluttman has written many articles and computer books, including Excel Charts for Dummies and O'Reilly's Access Hacks. His technical chops include Microsoft Office, XML, VBA, VB.NET, SQL Server, and assorted web technologies.

Wayne S. Freeze is head of software development for Electrical Controls, Inc. where he builds software 3D graphics applications using Visual Basic, SQL Server, and DirectX.

Additional Resources:
For more information about the book, including table of contents, index, author bios, and cover graphic, see: http://www.oreilly/catalog/9780596101220 9780596101220 -->