Microsoft 365 Access For Dummies, 2nd Edition

Chapter 10

Automatically Editing Data

IN THIS CHAPTER

Fixing your mistakes

Replacing data automatically

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 would hardly 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, fingertips, or brain!

Please Read This First!

The fact that you’re reading this tells me you’re a careful person who follows advice and instructions. Hopefully, you are, or can be when needed, because 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.

The reason I sound so serious is that when you’re making large-scale changes to a database, things can go wrong and mistakes ...