SELECT A TOPIC

Excel 2000
Working with Databases
Setting up a database

Setting up a database

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).



.
.
.
Records
(1 per row)
Column
labels

1.

Type Column Labels at the top of a worksheet, but do not use spaces.

2.

Fill in a record for each person or thing in the database. Each record must be unique.