Special Edition Using® Microsoft® Office Excel 2003

Chapter 17. Setting Up a List or Database in Excel

In this chapter

• Using Excel as a Database Program

• Building an Effective List

• Creating Structured Lists from Data Contained in One Cell

• Working with the Data Form

• Viewing and Printing the List

Using Excel as a Database Program

Although “number crunching” is Excel’s primary purpose, the row-and-column format lends itself to creating and storing databases (called lists in Excel). Generally, a good general rule is that if your list grows to more than 2,000 rows, you should consider storing the information in a data warehouse or relational database such as Microsoft Access. Whether you need to store a product catalog for quick lookups or employee information for use with your accounting software, you can ...