Chapter seven, "Importing and Exporting Data," handles the various methods of moving data into and out of Access. You will work with various methods such as the FileSystemObject, XML as well as communicating with SQL Server. Chapter eight, "Date and Time Calculations" shows you various ways of manipulating date and time data.
Chapter nine, "Business and Finance Problems," gives you the tools to solve a wide variety of business-related problems. These include weighted averages, moving averages, calculating depreciation, charting data and finding trends. Finally the last chapter, "Statistics," explores the variety of methods for working with statistics from within Access. These include mean, mode and median as well as variance, correlation permutations and combinations.
As with all of the O'Reilly Cookbooks, if you work with a product like Access, you should have something like Access Data Analysis Cookbook around. First, when you get the book you skim/read through it touching on things that perhaps you have never thought of to do. Then you keep it on your shelf because you will find yourself referring to it constantly when working with large amounts of data within Access.
Article comments