Creating Databases

When you need to store a large amount of data that consists of related records, you can create a database. For example, you can create a database that records all your business' sales, your customers' contact details, or the ups and downs of your stock-trading transactions.

To create a database, you first enter the fields that will contain the data. You then tell Excel that you're creating a database rather than a regular worksheet. After that, you add your data to the database, either by typing it into the cells as usual or by using a data-entry form (which is usually more convenient).

Once the data is in the database, you can sort the database to reveal different aspects of its contents, or filter it to identify items that ...

Get Office 2010 Made Simple now with O’Reilly online learning.

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