1-866-245-5224 sales@keystonelearning.com

Access 2007: Find & Replace

Access 2007: Find & Replace

You’ve already learned how to enter data into your form 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 form (field by field) for a specific word, phrase or data in your table. This is particularly useful when searching for data that appears more than once.

Figure 24. Find Dialog Box

Using Find to Locate Data

1.       From the Home Tab, click Find in the Find Group

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

3.       Set your options

4.       Click Find Next

5.       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 25. Replace Dialog Box

Using Replace to Modify Data

1.       From the Home Tab, click Replace in the Find Group

2.       Click Options to expand the Dialog Box

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

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

5.       Set your options

6.       Click Replace or Replace All

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