{"product_id":"access-data-analysis-cookbook-slicing-and-dicing-to-find-the-results-you-need-9780596101220","title":"Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need","description":"\u003cp\u003eIf 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. \u003cem\u003eAccess Data Analysis Cookbook\u003c\/em\u003e 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.\u003cbr\u003e\u003cbr\u003eWhether 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: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDevelop basic and sophisticated queries\u003c\/li\u003e\n\u003cli\u003eApply aggregate functions, custom functions, regular expressions, and crosstabs\u003c\/li\u003e\n\u003cli\u003eApply queries to perform non-passive activities such as inserting, updating, and deleting data\u003c\/li\u003e\n\u003cli\u003eCreate and manipulate tables and queries programmatically\u003c\/li\u003e\n\u003cli\u003eManage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text\u003c\/li\u003e\n\u003cli\u003eUse arrays, read and write to the Windows registry, encrypt data, and use transaction processing\u003c\/li\u003e\n\u003cli\u003eUse the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products\u003c\/li\u003e\n\u003cli\u003eFind 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\u003c\/li\u003e\n\u003cli\u003eDeal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (ROI)\u003c\/li\u003e\n\u003cli\u003eExplore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutations\u003c\/li\u003e\n\u003c\/ul\u003e\u003cem\u003eAccess Data Analysis Cookbook\u003c\/em\u003e 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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e O'Reilly Media\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 06\/05\/2007\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9780596101220\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 370\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.26lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.16h x 7.10w x 0.89d\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003eReview Citations: \u003c\/strong\u003e\u003ci\u003eScitech Book News\u003c\/i\u003e 12\/01\/2008 pg. 28\u003cbr\u003e","brand":"Ken Bluttman, Wayne S. Freeze","offers":[{"title":"Default Title","offer_id":42289420763317,"sku":"9780596101220","price":42.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_1860919b-28d3-4b3b-a5c0-d18c690b802f.jpg?v=1658199555","url":"https:\/\/pastforward.org\/products\/access-data-analysis-cookbook-slicing-and-dicing-to-find-the-results-you-need-9780596101220","provider":"Past Forward","version":"1.0","type":"link"}