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

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
     
  1. Click the Find command on the Standard toolbar
     
  2.  
  3. Enter your data in the Find What: box (such as ABC Corporation)
     
  4.  
  5. Set your options
     
  6.  
  7. Click Find Next
     
  8.  
  9. 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
     
  1. Click the Find command on the Standard toolbar
     
  2.  
  3. Click the Replace tab
     
  4.  
  5. Enter your data in the Find What: Box (such as ABC Corporation)
     
  6.  
  7. Enter your data in the Replace With: Box (such as XYZ Industries)
     
  8.  
  9. Set your options
     
  10.  
  11. Click Replace or Replace All
     
  12.  
  13. When you are finished searching your worksheet or workbook, click Cancel