Access Database Analysis Cookbook BY.S.FREEZE (9788184043334)

If you have large quantities of data in a Microsoft Access database—and you need to study that data in depth—this book is your dream. Access Data Analysis Cookbook 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, and a discussion on how and why it works.

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 use your data and not just store it? Access Data Analysis Cookbook is the book you need for extracting nuggets of valuable information from your database.?About the Authors?Ken Bluttman?is the author of numerous computer books and articles. He recently released O’Reilly’s Access Hacks as well as Excel Charts for Dummies. Ken is also at work on his next O’Reilly book: The Access Data Cookbook (due out at the end of 2005). His technical chops include Microsoft Office, XML, VBA, VB.Net, SQL Server, and assorted web technologies. Ken is a musician, nature lover, and as time allows spins a good dish in the kitchen. Visit Ken at www.bluttman.com.?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