Access 2019 For Dummies

Easy steps to practical databases

People who really know how to build, populate, and simplify databases are few and far between. Access 2019 For Dummies is here to help you join the ranks of office heroes who possess these precious skills.

This book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports. In short, it’s the book that holds all the secrets behind the mysteries of Access!

• Build effective databases from the ground up
• Simplify your data entry with forms and tables
• Write queries that produce answers to your data questions
• Simplify input with forms

There’s no time like the present to get your hands on the insight that database beginners need to become Access gurus.

Table of Contents

Part 1: Basic Training
Chapter 1: Access 2019 Basic Training
Chapter 2: Navigating the Access Workspace
Chapter 3: Database Basics

Part 2: Getting It All on the Table
Chapter 4: Sounds Like a Plan
Chapter 5: Table Tune Ups
Chapter 6: Remodeling Your Data
Chapter 7: Types, Masks, and Triggers

Part 3: Data Management Mania
Chapter 8: A Form for All Reasons
Chapter 9: Importing and Exporting Data
Chapter 10: Automatically Editing Data
Chapter 11: Access and the Web

Part 4: The Power of Questions
Chapter 12: Finding, Filtering, and Sorting Your Data — Fast
Chapter 13: I Was Just Asking … for Answers
Chapter 14: I Want These AND Those OR Them
Chapter 15: Number Crunching with the Total Row
Chapter 16: Express Yourself with Formulas
Chapter 17: Take Charge with Action Queries

Part 5: Simple and Snazzy Reporting
Chapter 18: Fast and Furious Automatic Reporting
Chapter 19: Professionally Designed Reports Made Easy
Chapter 20: Groups and Page Breaks, Headers and Footers
Chapter 21: Mailings to the Masses

Part 6: The Parts of Tens
Chapter 22: Ten Common Problems
Chapter 23: Ten Uncommon Tips

Appendix A: Getting Help