Access 2003: Find & Replace

Access 2003: Find & Replace

You’ve already learned how to enter data into your table and you even know how to edit data that is already there. But, let’s look at a scenario:

It’s Monday morning and your boss just walked into your office to let you know your company is merging with another. Effectively immediately, your company is no longer called ABC Corporation. Now, you’re a member of XYZ Industries. Not to worry, though. Your paychecks will be uninterrupted because you’re the only one who knows how to quickly change every entry to reflect the new company name. Right?

It’s a good thing you’re taking this course because I’m about to show you how to tackle this project. We’re going to look at two different areas:

Find

Replace

Find

The Find feature quickly searches your table (cell by cell) for a specific word, phrase or data in your table. This is particularly useful when searching for data that appears more than once.

Figure 16. Find Dialog Box

Using Find to Locate Data

Click the Find command on the Standard toolbar

Enter your data in the Find What: box (such as ABC Corporation)

Set your options

Click Find Next

When you are finished searching your worksheet or workbook, click Cancel

Replace

The Replace feature actually works in conjunction with the Find feature by first searching for specific data and then replacing it with new data.

Figure 17. Replace Dialog Box

Using Replace to Modify Data

Click the Find command on the Standard toolbar

Click the Replace tab

Enter your data in the Find What: Box (such as ABC Corporation)

Enter your data in the Replace With: Box (such as XYZ Industries)

Set your options

Click Replace or Replace All

When you are finished searching your worksheet or workbook, click Cancel