Название: Exploring Data with Access 2019
Автор: Larry Rockoff
Издательство: Deep Dive Press
Год: 2020
Страниц: 416
Язык: английский
Формат: pdf, epub
Размер: 60.5 MB

Exploring Data with Access 2019 is an introduction to 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 a computer as you read the book.

Special 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 useful 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.

The title of this book indicates that the book is about both data and Microsoft Access. The emphasis, however, is using Microsoft Access as a means to explore and analyze data. There are already many fine books that cover the nuts and bolts of Access from A to Z, but very few discuss Access with the goal of learning what it can accomplish as a data exploration and analysis tool. This is such a book.

Right from the start, we’re going to invoke the term “data analysis” as a way to state this book’s intended goal. But if you’re wondering what data analysis actually means, you’re not alone. It’s certainly an overused and somewhat trite term, and one that can be interpreted in many different ways. As a result, before looking at Access itself, most of Chapter 1 will be devoted to a general discussion of data analysis and how it relates to Access.

As we’ll learn in Chapter 2, Access is comprised of five major components: tables, queries, forms, reports, and macros. The emphasis in this book is on queries. To a lesser extent, we will also cover tables. Forms, reports, and macros are of limited importance for the data analyst and are therefore covered only marginally in this book.

Access 2019 is available in both Office 2019 and Microsoft 365 versions. With Microsoft’s move to subscription services, we anticipate that most users will be using Access as part of their Microsoft 365 subscription. As such, all screenshots in this book are taken from the Microsoft 365 version of Access. There may be some subtle differences in the user interface for those using Office 2019.