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 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.
