Updating Information in a Table

As you use a database and as it grows, you might discover that errors creep in or that some information becomes out of date. You can tediously scroll through the records looking for those that need to be changed, but it is more efficient to use a few of the tools and techniques provided by Access for that purpose.

If an employee has consistently misspelled the same word, you can use the Find and Replace commands on the Edit menu to locate each instance of the misspelled word and replace it with the correct spelling. This command works much like the same commands in Microsoft Office Word or Microsoft Office Excel.

However, if you decide to increase the price of some products or replace the content of a field only under ...

Get Microsoft® Office System Step by Step -- 2003 Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.