Chapter 16. Analyzing Tabular Information with Functions

Understanding Database Functions

Do not let the word database frighten you. A database is nothing more than a collection of related information. The telephone book is a simple database that contains name, address, and telephone number information for many people. In database terminology, each person's entry in the book is considered a record, and each record is composed of fields. In the telephone book analogy, the person's first name is a field, the person's last name is another field, the street address is another field, and so on. When you set up a database, you can decide which fields you want to include. For example, you can store the city, state, and ZIP code as one field or as three ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.