Access 2016 For Dummies, 1st Edition

  • Laurie Ulrich Fuller
  • Ken Cook
  • Published By:
  • 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

  • Price:  Sign in for price



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.
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.
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, and she welcomes reader questions at