Access Books

Exploring Data with Access 2019

Published by Deep Dive Press in December 2020, paperback and eBook, 292 pages.

Click here to purchase the book on Amazon in the US

EXPLORING DATA WITH ACCESS 2019 is an introduction to Microsoft Access with an emphasis on topics relevant to data exploration and analysis. The goal is to help the analyst gain a true understanding of data and the information it contains. Access queries are covered in detail, both in terms of the mechanics of their design and how they can be used for typical data analysis tasks. The book is written in an easy-to-understand tutorial style, with new topics introduced in a logical and intuitive sequence. Numerous screenshots are included, so you won’t need to sit with a computer as you read the book.

Additional features include “See the SQL” sidebars that allow interested readers to learn SQL as they are learning Access and “Focus on Analysis” sidebars that provide details on a number of quantitative topics.

In short, this is the only book you’ll need to gain a working knowledge of Access, and how it can be used for data exploration and analysis.

Table of Contents

1. What is Data Analysis?
2. An Overview of Access
3. Tables and External Data
4. Select Queries
5. Joins and Relationships
6. Relational Database Design
7. Expressions and Functions
8. Selection Criteria
9. Summarizing Data
10. Subqueries and Set Logic
11. Action Queries
12. Crosstab Queries and Pivot Tables

Appendix: Forms, Macros, and Reports

Purchasing the Book

Print editions can be purchased from these online bookstores in the US:

Amazon
Barnes and Noble

These sites in the US offer digital editions:

Amazon (Kindle)
Apple iTunes Store (iBook)
Barnes and Noble (Nook Book)

Print editions can be purchased from these online bookstores outside of the US:

Amazon Canada
Amazon France
Amazon Germany
Amazon Spain
Amazon UK

These sites outside of the US offer digital editions:

Amazon Canada (Kindle)
Amazon France (Kindle)
Amazon Germany (Kindle)
Amazon India (Kindle)
Amazon Spain (Kindle)
Amazon UK (Kindle)
Indigo in Canada (Kobo eBook)