O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required