1.

To begin, start Excel and open the file named Practice 8 in your Excel 2003 Practice folder.

You can use File->Open, or click the file open button on the standard tool bar.

Here we have a worksheet containing records on several individuals. Each record has for fields, namely Name, Age, Height, and Weight.

Your fist step is to display a data form for this list. You can do this by clicking on any cell in the list, and choosing Data->Form from the menu bar.

2.

When you see the data form, click the new button.

You should see the words New Record on the top right area of the form. This means that the form is ready for you to enter a new record.

In the empty field boxes, type the name Marvin, the age 32, the height 72, and the weight 181. Do not press enter after you complete each field, but move to the next field by pressing the Tab key, or by clicking on it. If you press enter, what ever is in the fields, will be entered as a record.

3.

This is what your form should look like after you type the information in the field boxes. You can see the blue asterisk in the list just below the name Brenda. This is where the new record will be placed.

Press Enter to enter the record.

Now you can see the new record at the bottom of the list.

The form is ready for you to enter another record if you wish. Your next step, however, will be to find and delete a record.

You can quickly find a record by clicking the criteria button.

This will prepare the form to search for records based on the criteria you enter.

Let’s say that you know the record you are looking for has 44 in the age field.

4.

To begin, click the Criteria button on the form.

You will see the word Criteria in the upper right of the form. Type 44 in the age field, and click the Find Next button.

You will see the field values for the first record with an age value of 44. This is not the person we are looking for so click Find Next again.

5.

You will now see the record for a person named Chuck. You have found the person you want to remove from the list, so the next step is to click the Delete button. Before you delete the record, not its position in the list.

6.

 
After you click the Delete button, you will see the following alert. If you are not sure that you want to remove the record, click Cancel.

 For this exercise, click OK to delete the record.

Notice that the person named Chuck has been removed from the list. Click the Close button on the form, Save your work, and exit Excel.