Access Data Analysis Cookbook is just that, a cookbook that contains a lot of recipes for you to work with your Access databases to the best advantage. The goal is that if you have large quantities of data stored in a Microsoft Access database and you need to study that data, you need tools to help you study it. That is where Access Data Analysis Cookbook comes in. It provides those tools.
Access Data Analysis Cookbook divides out in to ten chapters based on function. While the recipe solutions apply to all versions of Access, the examples and figures represented in the book are from Access 2003 and Access 2007. Each new edition has bells and whistles, but the core factors of SQL, VBA, DAO and ADO have remained the same.
Chapter one, "Query Construction," explains how to develop basic as well as sophisticated queries. Here issues such as use of operators, creating unions and understanding how the differing join types work. Chapter two, "Calculating with Queries" advances chapter one by using queries to find answers to real world problems. Here you will learn how to use aggregate functions, custom functions, regular expressions and crosstabs.
Chapter three, "Action Queries," shows you how to apply queries to perform actions upon the data that is being pulled back. Here you can alter the results set based on the criteria that you provide. Chapter four, "Managing Tables, Fields, Indexes and Queries," will show you how to create each of these items programmatically using code.
Chapter five, "Working with String Data," does just that, it show you how to work with the string data that you pull back from your query. "Chapter six, "Using Programming to Manipulate Data," shows you how to use arrays read, and write to the registry, how to encrypt data, and how to use transaction processing.
Article comments