Access Data Analysis Cookbook (Paperback)

Description

If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.

Whether you use Access 2007 or an earlier version, this book will teach 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 more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to:

• Develop basic and sophisticated queries
• Apply aggregate functions, custom functions, regular expressions, and crosstabs
• Apply queries to perform non-passive activities such as inserting, updating, and deleting data
• Create and manipulate tables and queries programmatically
• Manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text
• Use arrays, read and write to the Windows registry, encrypt data, and use transaction processing
• Use the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products
• Find answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculations
• 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, combinations and permutations

Access Data Analysis Cookbook is a one-stop-shop for extracting nuggets of valuable information from your database, and anyone with Access experience will benefit from these tips and techniques, including seasoned developers. If you want to use your data, and not just store it, you'll find this guide indispensable.

描述

如果您在Microsoft Access数据库中有大量的数据，并且需要深入研究这些数据，那么这本书将是数据分析者的梦想。《Access数据分析食谱》提供了解决用户在提取Access数据和进行计算时遇到的各种常见问题的实用方法。每个方法都包括对解决方案的讨论，以及解决方案的工作原理和原因。

无论您使用的是Access 2007还是早期版本，本书都将教您查询数据的新方法，将数据移入和移出Access的不同方式，如何计算财务和投资问题的答案等等。学习如何应用统计方法总结业务信息，如何通过VBA操作数据超越SQL，如何处理日期和时间，甚至如何使用Excel数据分析工具包。食谱演示了以下方法：
- 开发基本和复杂的查询
- 应用聚合函数、自定义函数、正则表达式和交叉表
- 应用查询执行非被动活动，如插入、更新和删除数据
- 以编程方式创建和操作表和查询
- 管理基于文本的数据，包括隔离字符串的部分和处理存储为文本的数字的方法
- 使用数组，读写Windows注册表，加密数据和使用事务处理
- 使用FileSystemObject，使用XSLT处理XML，与SQL Server通信，并与其他Office产品交换数据
- 从基于时间的数据中找到答案，例如如何添加时间，计算经过的时间，处理闰年以及在计算中管理时区
- 处理业务和财务问题，包括计算折旧、贷款偿还和投资回报率（ROI）的方法
- 探索统计技术，如频率、方差、峰度、线性回归、组合和排列

《Access数据分析食谱》是从数据库中提取有价值信息的一站式解决方案，任何有Access经验的人都将从这些技巧和方法中受益，包括经验丰富的开发人员。如果您想使用数据而不仅仅是存储数据，您会发现这本指南是不可或缺的。