SQLConfiguration SQLConfiguration





Finding, Filtering, Sorting  «Prev  Next»
Lesson 2 Finding data in a table
Objective Use the Find and Replace dialog box.

Finding data in an Access Table

Sometimes you just need to find a particular piece of data within a table, perhaps you remember the name and need to find the address. The Find and Replace dialog box is the perfect solution because it allows you to search for one piece of data within one table.
To use the Find and Replace dialog box you need to know which table the data you are looking for is in.
Open that table before you begin your search.
The following simulation shows you how to use the Find and Replace dialog box to find the data you are looking for.

finding Data in Table
In the next lesson you will learn how to sort records in a table.



Finding a Specific Value

Although you can move to a specific record (if you know the record number) or to a specific field in the current record, usually you will want to find a certain value in a record.
You can use one of these methods for locating a value in a field:
  1. Select the Find command (a pair of binoculars) from the Find group of the Ribbon.
  2. Press Ctrl+F.
  3. Use the Search box at the bottom of the Datasheet window.
The first two methods display the Find and Replace dialog box (shown in Figure 2.2). To limit the search to a specific field, place your cursor in the field you want to search before you open the dialog box.
Change the Look In combo box to Current Document to search the entire table for the value.

The Find and Replace dialog box. The fastest way to activate it is to simply press Ctrl+F
Figure 2.2 The Find and Replace dialog box. The fastest way to activate it is to simply press Ctrl+F.

The Find and Replace dialog box lets you control many aspects of the search. Enter the value you want to search for in the Find What combo box, which contains a list of recently used searches. You can enter a specific value or choose to use wildcard characters.