Press Release


Email. Email press release link

May 30, 2007

O'Reilly Releases Access Data Analysis Cookbook: 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) 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.

Additional Resources:

More information about the book, including table of contents, index, author bios, and cover graphic

Access Data Analysis Cookbook
Ken Bluttman and Wayne S. Freeze
ISBN: 0-596-52986-4, 238 pages, Print: $34.99 US, $45.99 CA
order@oreilly.com
1-800-998-9938; 1-707-827-7000

About O'Reilly

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.

Return to: O'Reilly Press Room

Recent Press Releases


8/4/14 O'Reilly Media Acquires Full Ownership of Safari Books Online
2/26/14 Solid Heralds the Merging of the Physical and Virtual Worlds
2/4/14 O'Reilly Media & Safari Books Online Donate Over $100 Million in Technology Education Resources to US K-12 Schools
12/3/13 Windows 8.1: The Missing Manual--New from O'Reilly Media
11/20/13 iPad: The Missing Manual, 6th Edition--New from O'Reilly

Press Release Archive »

Resources

Press Contacts

Corporate

Sara Winge
800/998-9938 x7109

Media Relations - North America

Sara Peyton
800/998-9938 x7118

Media Relations - Germany

Corina Pahrmann
+49-221-973160-22

Media Relations - Japan

Kenji Watari
+81-3-3356-5227

Media Relations - United Kingdom

Helen Coding
+44 (0)1252-721284

Media Relations - Conferences

Maureen Jennings
800/998-9938 x7083