Microsoft Office Tutorials and References
In Depth Information
Chapter 17: Playing Records with Database Functions
Figure 17-1 shows a database on a worksheet. This example is a list of
students (by ID number) and their class, teacher, and grade. Each student
occupies a row — in other words, a record — in the database. Each of the four
fields — Student ID, Class, Teacher, and Final Grade — is in one column and
is identified by a label in the top row.
The data on the worksheet in Figure 17-1 is really just normal data. There is
nothing special about it. However, the data sits in organized rows and
columns, making it ready for working with Excel’s database functions:
✓ Each column is a field that holds one particular item of data, such as
Student ID or Class. It must contain no other data.
✓ Each row contains one record. In this example, a record is the data for
✓ The top row of the database contains labels that identify the fields.
This sample data is used in this chapter to demonstrate the database
functions. Of course, you can have a database in Excel and never use the
database functions, but you have a lot more power at your fingertips if you do