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. The 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;
and, use the FileSystemObject, use XML with XSLT, communicate with
SQL Server, and exchange data with other Office products. They also
demonstrate ways to: 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); and, 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.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
