EXCEL AS A DATABASE

Excel, like many other spreadsheet programs, allows the user to create a database, also known in Excel as a List.

By using your worksheet as a database you can easily store and manipulate complex data or large amounts of data.

You can use the database in Excel to:

THE PARTS OF A DATABASE

data1

Database Range or List

A database range is a rectangular range of worksheet cells defined as a database.
In the example the database range or List would extend from B2 to G8.

Record

A record is a single row in the list.
Each record contains the same categories of data as every other record in the list.

Field

Each column in the List is a separate field.
Text, numbers, dates, formulae or functions can be entered into any field.

Computed Field

A field containing formulae or functions, ie VALUE from above.

Field Name

A field name is a name that identifies the data stored in a field.
The top row of the List should contain the field names.