Microsoft Office Tutorials and References
In Depth Information
Searching a Database
Searching a Database
A paper database is useful for storing information, but not so useful for
finding it again. If you have a thousand business cards stored in a Rolodex file,
how much time do you want to waste trying to find the phone number of a
single person?
Searching a database is crucial to make your data useful, so Access provides
two ways to search a database:
Search for a specific record.
Use a filter to show one or more records that meet a specific criterion.
Searching for a specific record
The simplest type of search looks for a specific record. To search for a
record, you need to know the data stored in at least one of its fields, such as
a phone number or e-mail address.
The more information you already know, the more likely Access will find the
one record you want. If you search for all records that contain the first name
Bill, Access could find dozens of records. If you just search for all records
that contain the first name Bill, the last name Johnson, and a state address of
Alaska, Access will likely find just the record you want.
To search for a specific record in a database table, follow these steps:
1. In the All Tables pane on the left of the screen, double-click the name
of the database table you want to search.
Access displays the Datasheet view of your database.
2. Click the Home tab.
3. Click the Find icon in the Find group.
The Find and Replace dialog box appears, as shown in Figure 17-1.
4. Click in the Find What text box and type in the data you know is
stored in the record you want to find.
For example, if you want to find the phone number of a person but you
know only that person’s last name, you type that person’s last name in
the Find What text box.
5. Click the Look In list box and choose Current field or Current
Search JabSto ::

Custom Search