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.
Figure 17-1:
Using a
database
to store
student
information.
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
one student.
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
use them.
Search JabSto ::




Custom Search