Basic Database Concepts

In your earlier work with Excel, you created worksheets to store and summarize information or data. Often you organize this information so that you can easily find the entries for a series of values, or calculate the totals for a group of numbers.

In Excel, a database is simply a more organized set of data. By organizing the data into a database, you can use the built-in database commands to find, edit, and delete selected data without manually scrolling through the information.

Database A tool you use to store, organize, and retrieve information. Excel treats the database as a simple list of data. You enter the database ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours 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.