Access 2019 For Dummies [Paperback]

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.

Introduction 1

About This Book 1

Foolish Assumptions 2

Icons Used in This Book 2

Where to Go from Here 3

Part 1: Basic Training 5

Chapter 1: Access 2019 Basic Training 7

What Is Access Good For, Anyway? 8

Building big databases 8

Creating databases with multiple tables 9

Databases with user forms 12

Databases that require special reporting 13

What’s New in Access 2019? 16

Reach Out with SharePoint 17

How Access Works and How You Work with it 18

Opening Access 18

Selecting a starting point 1lı