O'Rielly Access Data Analysis Cookbook May 14, 2007 - 368 Pages - PDF - 6.5 MB
Recipes demonstrate waysto:
- 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 astring 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 SQLServer, and exchange data with other Office products
- Find answers from time-based data, such as how to add time, countelapsed time, work with leap years, and how to manage time zones in yourcalculations
- Deal with business and finance problems, including methods forcalculating depreciation, loan paybacks, and Return on Investment (ROI)
- Explore statistical techniques, such as frequency, variance,kurtosis, linear regression, combinations and permutationsAccess Data Analysis Cookbook is a one-stop-shop for extracting nuggetsof valuable information from your database, and anyone with Accessexperience will benefit from these tips and techniques, includingseasoned developers. If you want to use your data, and not just storeit, you'll find this guide indispensable.