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 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.
Why do I sound so serious, all of the sudden? Well, ...