O'Reilly logo

Access 2019 For Dummies by Ken Cook, Laurie A. Ulrich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10

Automatically Editing Data

IN THIS CHAPTER

check Fixing your mistakes

check Replacing data automatically

check Finding unwanted duplications in your data

Correcting an incorrect entry in an Access table is pretty easy: A few clicks, some typing, and voilà — the problem is gone. But what if you need to correct 26,281 records? Manually editing so many records would involve an eternity of clicking and typing and hardly qualifies to end in a victorious “Voilà!”

Fortunately, Access offers some handy, large-scale editing tools you can use to make big changes to your database — all without wearing out your keyboard, mouse, or fingertips.

Please Read This First!

warning After a heading like that, it cannot be a mystery to you that I think you really need to read this section. Why? Because the fact that you’re reading this tells me you’re a careful person who follows advice and instructions. These traits are the key to managing thousands of records, keeping them accurate and up-to-date, and making the types of corrections I talk about in this chapter.

Why do I sound so serious, all of the sudden? Well, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required