Microsoft Office Tutorials and References
In Depth Information
Finding a Missing Record
Finding a Missing Record
Sometimes data goes astray. You scroll through a datasheet but simply can’t
find the item or record you need so badly. For times like those, Access offers
the Find command. Use the command to scour a database for errant
Open the database table with the data that needs finding. If you know in
which field the data is located, click in the field. You can save a little time
that way. Then, on the Home tab, click the Find button (or press Ctrl+F). You
see the Find and Replace dialog box, as shown in Figure 3-4. Fill in the dialog
box as follows:
Figure 3-4:
Find What: Enter the item you’re looking for. If you’re looking for a null
value, enter null in this text box. Enter “” (two double-quotation marks)
to find zero-length strings. Table 3-2 describes the wildcard characters
you can use in searches.
Look In: If you clicked in a field before choosing the Find command,
Current Field is selected in this box. To search the entire database table,
choose Current Document on the drop-down list.
Match: Choose the option that describes what you know about the item.
Choosing the Any Part of Field option can make for a long search. For
example, a search for the letters chin finds, among others, China, Ching,
and itching — any word with the consecutive letters chin.
Search: Choose an option — All, Up, or Down — that describes which
direction to start searching.
Match Case: If you know the combination of upper- and lowercase
letters you’re after and you enter the combination in the Find What text
box, select this check box.
Search Fields As Formatted: If you’re searching for a field that has
been formatted a certain way, select this check box and make sure that
the text or numbers you enter in the Find What text box are formatted
correctly. For example, if you’re searching for a record with the date
July 31, 1958, and you choose the /yyyy format, enter the date as
Search JabSto ::

Custom Search