Access Data Analysis Cookbook (with source code)

Access Data Analysis Cookbook is about solutions to real-world problems. This is not a book about designing forms, learning about primary keys, or discussing the use of built-in wizards to make easy queries or reports. This book is about applying Access to the business grindstone.

Within the dozens of recipes contained in this book, you will learn new ways to query data, how to move data in and out of Access in several different ways, how to calculate answers to financial and investment questions, and much, much more.

I would not suggest this book for brand-new Access users, but anyone with some Access experience should do well with it. As long as you understand how to get around the Access user interface, basic table structures and relations among them, and  how  to  construct  simple  queries,  you  should  be  able  to  follow  along. Even seasoned developers will pick up new tips and techniques. Considering that many recipes center around business issues rather than technical issues, everyone should be  able  to  gain  some  smarts  about  analysis  and  reporting—the  world  that  users inhabit.

Access Data Analysis Cookbook focuses on data. The recipes provide example queries, programming tips, and a smattering of math, all with a view to getting answers from your data.