Access Data Analysis Cookbook

by Bluttman, Ken

• ISBN13: 9780596101220
• ISBN10: 0596101228
• Format: Paperback
• Copyright: 2007-05-01
• Publisher: Oreilly & Associates Inc

Summary

Whether you're part of an organisation, a research institute, or a home user who needs to conduct an in- depth study of data in a Microsoft Access database, this is your book. "Access Data Analysis Cookbook" offers a collection of practical ways you can use Access to analyse data and then present the analysis. The first part of the book shows you how to extract the data you need to work with, while the second shows you how to perform calculations on it. If you want to use your data, and not just store it, you will find this lone guide on the subject invaluable.

Author Biography

Ken Bluttman is the author of numerous computer books and articles. He recently wrote O'Reilly's "Access Hacks" as well as "Excel Charts for Dummies". Ken's technical chops include Microsoft Office, XML, VBA, VB.NET, SQL Server, and assorted web technologies.

Wayne S. Freeze is the Head of Software Development for Electrical Controls, Inc., where he builds software 3D graphics applications using Visual Basic, SQL Server and DirectX. He has written more than a dozen books over the years and has over seventy-five articles to his credit. Wayne has been using and writing about Access for nearly ten years, and has over 30 years of experience using all types of computers, from small, embedded microprocessor control systems to large-scale IBM mainframes. He also has a master's degree in management information systems as well as degrees in computer science and electrical engineering.

Table of Contents

Query Construction

Calculating with Queries

Action Queries

Managing Tables, Fields, Indexes, and Queries

Working with String Data

Using Programming to Manipulate Data

Importing and Exporting Data

Date and Time Calculations

Business and Finance Problems

Statistics

Table of Contents provided by Publisher. All Rights Reserved.