Chapter 17. Setting Up a List or Database in Excel
In this chapter
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 ...
Get Special Edition Using® Microsoft® Office Excel 2003 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.