Microsoft Excel 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 A to Z option to sort the database alphabetically.
   
   
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 check box next to the Select All option to clear all check boxes.
   
   
3. Click on the check box next to the Business option to add a check mark to the box.
   
   
4. Click OK.
   
   
5. Only two students - G. Thompson and F. Smith should be visible since they are the only two enrolled in the business program.
   
   
6. To show all records, click on the drop down arrow next to the Program field name.
   
   
7. Click on the Clear Filter from "Program" option.
   
   

Return to Index page

Previous

• Excel Database Overview
• Tables of data
• Entering Data Correctly
• Rows are Records
• Columns are Fields
• Creating the Table
• Using the Database Tools
• Expanding the Database
• Completing the Database Formatting

Next