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) 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.
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.
Access Data Analysis Cookbook
Ken Bluttman and Wayne S. Freeze
ISBN: 0-596-52986-4, 238 pages, Print: $34.99 US, $45.99 CA
O’Reilly Media spreads the knowledge of innovators through its books, online services, magazines, and conferences. Since 1978, O’Reilly Media has been a chronicler and catalyst of cutting-edge development, homing in on the technology trends that really matter and spurring their adoption by amplifying “faint signals” from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.