Excel 2003 Step by Step Database Tutorial

By Ted French, About.com Guide

Using the Database Tools

For help on these steps, refer to the image above.

Once you have created the database, you can use the tools located under the drop down arrows beside each field name to sort or filter your data.

Sorting Data

1. Click on the drop down arrow next to the Last Name field name.
   
   
2. Click on the Sort Ascending option to sort the database alphabetically from A to Z.
   
   
3. Once sorted, Graham J. should be the first record in the table and Wilson . R should be the last.

Filtering Data

1. Click on the drop down arrow next to the Program field name.
   
   
2. Click on the Business option to filter out any students not in the business program.
   
   
3. Click OK.
   
   
4. Only two students - G. Thompson and F. Smith should be visible since they are the only two enrolled in the business program.
   
   
5. To show all records, click on the drop down arrow next to the Program field name.
   
   
6. Click on the All option.
   
   

Return to Index page

Previous

• Excel Database Overview
• Creating Tables and Lists
• Entering Data Correctly
• Rows are Records
• Columns are Fields
• Creating the List
• Using the Database Tools
• Entering New Records in an Excel Database
• Formatting the Database

Next