Office 2007 Bible

Understanding Tables (Lists) and Databases

Databases are organized collections of information. In that sense, practically every list of data you’ve ever used has been a database.

Defining databases and tables

Databases and tables are the same thing in Excel. Although Microsoft defines a table in Excel as “a series of rows and columns that contains related data,” that’s a pretty good thumbnail description of a basic database, and many worksheets that people create fit that definition.

Previous versions of Excel called a database on a worksheet a list. Excel 2007 now uses the term table, and you can designate any range on a worksheet as a table. After you do so, you will be able to take advantage of tools for quickly sorting, filling, using formulas, and so on in the table.

Cross-Ref

The section called “Using Formulas in Tables” in Chapter 15 already presented basic information about using formulas in tables. This chapter focuses on the database-type capabilities for tables, instead.

Records and fields

Although you’re used to thinking in terms of rows and columns in Excel worksheets, when you’re using Excel to track lists of information as in a database program, the proper database parlance is to call the rows “records” and the columns “fields.” Thus, every database record (a row of cells) is composed of the data in each cell in that row (the individual field entries).

Whereas a row (or “record”) can contain many types of data, the data that goes into a particular column (or “field”) ...