Access 2016 For Dummies, 1st Edition

Laurie Ulrich Fuller
Ken Cook
Published By:

John Wiley & Sons

John Wiley & Sons, known in its early years for publishing works by Washington Irving, Edgar Allen Poe, Herman Melville and other literary giants, provides critical titles for academics as well as lifelong learners.
ISBN-10: 1119083087
ISBN-13: 9781119083085
DDC: 005.75
Grade Level Range: College Freshman - College Senior
456 Pages | eBook
Original Copyright 2016 | Published/Released June 2017
This publication's content originally published in print form: 2016

Pricing for eBooks is based on your account type and population served. Accurate pricing will only display for registered users. Click here to register. Once registered, you will receive an email confirmation and can shop for titles with accurate pricing applied to your order. If you choose not to register, please call your sales representative at 1.800.877.4253 or email galeord@cengage.com.

Price: Sign in for price
180147771120643167024905760931979041200

About

Overview

This expanded and updated edition of Access For Dummies covers all of the latest information and features to help data newcomers better understand Access' role in the world of data analysis and data science. Inside, you'll get a crash course on how databases work—and how to build one from the ground up. Plus, you'll find step-by-step guidance on how to structure data to make it useful, manipulate, edit, and import data into your database, write and execute queries to gain insight from your data, and report data in elegant ways.

Table of Contents

Front Cover.
Title Page.
Copyright Page.
Contents at a Glance.
Table of Contents.
Introduction.
Getting Started with Access 2016.
1: Access 2016 Basic Training.
2: Navigating the Access Workspace.
3: Database Basics.
4: Sounds Like a Plan.
Getting It All on the Table.
5: Table Tune Ups.
6: Remodeling Your Data.
7: Types, Masks, and Triggers.
Data Management Mania.
8: A Form for All Reasons.
9: Importing and Exporting Data.
10: Automatic Data Editing.
11: Access and the Web.
The Power of Questions.
12: Finding, Filtering, and Sorting Your Data — Fast.
13: I Was Just Asking … for Answers.
14: I Want These and Those OR Them.
15: Number Crunching with the Total Row.
16: Express Yourself with Formulas.
17: Take Charge with Action Queries.
Simple and Snazzy Reporting.
18: Fast and Furious Automatic Reporting.
19: Professionally Designed Reports Made Easy.
20: Headers and Footers and Groups, Oh My!.
21: Magical Mass Mailings.
More Power to You.
22: Analyze This!.
23: Steer Users in the Right Direction with Navigation Forms.
The Part of Tens.
24: Ten Common Problems.
25: Ten Uncommon Tips.
Appendix A Getting Help.
Index.
About the Authors.

Meet the Author

Author Bio

Laurie Ulrich Fuller

Laurie Ulrich Fuller has been writing about and teaching people to use Microsoft Office for more than 15 years – including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 25 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books on Excel include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing marketing, graphic design, and web development services to clients throughout the country, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions and outreach. You can visit her website at www.limehat.com, and she welcomes reader questions at help@limehat.com.