| ACCESS DATA ANALYSIS COOKBOOK SLICING AND DICING T |
If you have large quantities of data in a microsoft access database—and you need to study that data in depth—this book is your dream. access data analysis cookbook 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, and a discussion on how and why it works.
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 use your data and not just store it? access data analysis cookbook is the book you need for extracting nuggets of valuable information from your database.
Author : Ken bluttman, wayne s. freeze
Publication : O'reilly
Isbn : 9788184043334
Store book number : 103
NRS 600.00
|
 |
|
|
|
|
|
|
|
