Exploring Data with Access 2016
Author: Larry Rockoff
Published in September 2018, paperback and eBook, 306 pages.
EXPLORING DATA WITH ACCESS 2016 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.
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
Print editions can be purchased from these online bookstores in the US:
These sites in the US offer digital editions:
Print editions can be purchased from these online bookstores outside of the US:
These sites outside of the US offer digital editions: