			SELECT A TOPIC
	Excel 2000		Working with Databases		Using a data Form to add records

Using a data Form to add 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).

Instead of typing records into cells, you can add records to a database using a data form.


1.	Select any cell in the database.
2.	From the Data menu, choose Form, then click the New button. The data form dialog box appears.
3.	Fill in the fields for each record. Press TAB to go to the next field, press SHIFT+TAB to go to the previous field, and press ENTER in the last field to add a record to the database.
4.	To scroll through the list of records, use the Find Prev and Find Next buttons, or the scroll bar.
5.	When all records have been entered, click the Close button.