DBWebApplications 





Finding, Filtering, Sorting  «Prev 

Finding data in a table

  1. If you know which field the data you are looking for is in, you can place the cursor in any record in that field. For example, if you are looking for a client named Nora--the cursor can be placed in any of the first names in the First Name field. Click the Next button to move to the next screen.
  2. You can display the Find and Replace dialog box in one of the following ways: Press Ctrl+F ; Click the Find button on the toolbar (it looks like binoculars); Choose Edit>>Find from the menu. The Find and Replace dialog box has a number of options, we will go through the major ones in the next few screens. Click the Next button to move to the next screen.
  3. The most important option is the Find What option--use it to type the data that you are looking for in the table. In this case we have typed “Nora.” When you type the first character in the Find What field the Find Next button becomes active. Notice that the Find What box has an arrow to it's right--you can use this drop-down list to select text that you have searched for at some other time. Go ahead and click the arrow now to see what this might look like. Click the Next button to move to the next screen.
  4. You can also specify where you want to look for the text within the table. The Look In drop-down list allows you to choose from the field that the cursor was in when you displayed the Find and Replace dialog box and the entire table. Click the Next button to move to the next screen.
  5. The Match option allows you to specify if the text you typed in the Find What dialog box applies to the whole field or just part of it. For instance by choosing Any Part of Field from the Match option you could find all street addressees with “Ave” in them. Click the Next button to move to the next screen.
  6. You can use the More button to display additional options on the Find and Replace dialog box. Three new options are displayed: The Search option, which allows you to choose which direction to search from the cursor position (Up, Down, or All); The Match Case option, which, when selected, instructs Access to find the text as typed in the Find What box, matching all uppercase and lowercase letters; and the Search Fields As Formatted option, which finds data that is in the same display format as the data as you type into the Find What box. This option is rarely used. Click the Next button to move to the next screen.
  7. As a result of your search and replace for Nora, the text, “Nora”, that you are looking for is highlighted in the table. Be warned, though, that you must move the Find and Replace dialog box so that it does not hide the table.