Chapter 15. Excel Database Techniques

Unless you work with extremely large databases (thousands and thousands of sets of data) or you need a complex database structure, Excel can provide all the database power you’ll need.

In Excel, you enter data in rows. Each row is a record (one complete set of information). Each column in the row, called a field, contains one particular type of information in the record (Figure 15.1).

Each record of information occupies a row and each column is a field.

Figure 15.1. Each record of information occupies a row and each column is a field.

Rather than enter information directly in the cells of a sheet, you can also create a fill-in-the-blanks data form to make it easier to enter, edit, ...

Get Microsoft Office XP for Windows: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.