			SELECT A TOPIC
	Excel 2000		Working with Databases		Finding records

Finding records

A database is a list or table of information, consisting of Column Labels (data categories — e.g. name, address, age) and Records (information unique to each person or item in the database).


1.	Click any cell in the database.
2.	From the Data menu, choose Form, then click the Criteria button.
3.	In the field boxes, type your search specifications, e.g. person's first name and/or last name.
4.	Click the Find Prev or Find Next buttons to find the matching record(s).
5.	If the search fails, click the Criteria button, click Clear, and redo the search. Make sure that your spelling is correct.