Exploring Data with Access 2016 (eBook)

Larry Rockoff (Autor)

eBook Download: EPUB

2018 | 1st Edition
306 Seiten
Larry Rockoff (Verlag)
978-0-692-16358-0 (ISBN)

Infos

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 wont 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 youll need to gain a working knowledge of Access and how it can be used for data exploration and analysis.

Inhalt

What is Data Analysis?
An Overview of Access
Tables and External Data
Select Queries
Joins and Relationships
Relational Database Design
Expressions and Functions
Selection Criteria
Summarizing Data
Subqueries and Set Logic
Action Queries
Crosstab Queries and Pivot Tables


Appendix: Forms, Macros, and Reports

Produkt-Details

• Erscheint lt. Verlag: 20.9.2018
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Informatik ► Office Programme ► Access
• Schlagworte: ACCESS • Access 2016 • Data Analysis • Databases • Microsoft Access • Microsoft Access 2016 • SQL
• ISBN-10: 0-692-16358-1 / 0692163581
• ISBN-13: 978-0-692-16358-0 / 9780692163580