Exploring Data with Access 2016

Exploring Data with Access 2016

by Larry Rockoff
Exploring Data with Access 2016

Exploring Data with Access 2016

by Larry Rockoff

eBook1st Edition (1st Edition)

$11.49  $14.99 Save 23% Current price is $11.49, Original price is $14.99. You Save 23%.

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers


Overview

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


Product Details

ISBN-13: 9780692163580
Publisher: Larry Rockoff
Publication date: 09/20/2018
Sold by: Barnes & Noble
Format: eBook
Pages: 306
File size: 82 MB
Note: This product may take a few minutes to download.

About the Author

Larry Rockoff has been involved with reporting and business intelligence development for many years. His main area of interest is in using reporting tools to explore and analyze data in complex databases. He holds an MBA from the University of Chicago, with a specialization in Management Science. Besides writing about Access, he has also published books on Excel and SQL. A second edition of his bestselling book, "The Language of SQL," is available worldwide and has been translated into three languages.

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

From the B&N Reads Blog

Customer Reviews