John Wiley & Sons Access 2019 For Dummies Cover Easy steps to practical databases People who really know how to build, populate, and simplify datab.. Product #: 978-1-119-51326-1 Regular price: $25.62 $25.62 In Stock

Access 2019 For Dummies

Ulrich, Laurie A. / Cook, Ken


1. Edition December 2018
432 Pages, Softcover
Wiley & Sons Ltd

ISBN: 978-1-119-51326-1
John Wiley & Sons

Buy now

Price: 26,90 €

Price incl. VAT, excl. Shipping

Further versions


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

Part 1: Basic Training 5

Chapter 1: Access 2019 Basic Training 7

Chapter 2: Navigating the Access Workspace 25

Chapter 3: Database Basics 43

Part 2: Getting it All on the Table 61

Chapter 4: Sounds Like a Plan 63

Chapter 5: Table Tune Ups 75

Chapter 6: Remodeling Your Data 93

Chapter 7: Types, Masks, and Triggers 109

Part 3: Data Management Mania 133

Chapter 8: A Form for All Reasons 135

Chapter 9: Importing and Exporting Data 153

Chapter 10: Automatically Editing Data 167

Chapter 11: Access and the Web 179

Part 4: The Power of Questions 191

Chapter 12: Finding, Filtering, and Sorting Your Data -- Fast 193

Chapter 13: I Was Just Asking for Answers 209

Chapter 14: I Want These AND Those OR Them 235

Chapter 15: Number Crunching with the Total Row 243

Chapter 16: Express Yourself with Formulas 255

Chapter 17: Take Charge with Action Queries 269

Part 5: Simple and Snazzy Reporting 281

Chapter 18: Fast and Furious Automatic Reporting 283

Chapter 19: Professionally Designed Reports Made Easy 303

Chapter 20: Groups and Page Breaks, Headers and Footers 329

Chapter 21: Mailings to the Masses 351

Part 6: The Parts of Tens 359

Chapter 22: Ten Common Problems 361

Chapter 23: Ten Uncommon Tips 373

Appendix A: Getting Help 381

Index 383
Laurie Ann Ulrich has trained more than 20,000 people to make better, more creative use of their computers. She has created online courses and written more than 30 books.

Ken Cook built and manages a computer consulting business that has helped users for over 20 years. He's an expert at creating Microsoft Office and Access database solutions and teaches online Access courses.

L. A. Ulrich, Huntingdon Valley, Pennsylvania