Lesson 3 : Skiing Database Extra

Skiing Database Extra Questions

1. Add the following record to the database:



It is in FRANCE, the resort is VAL THORNES, the snow depth on the lower slopes of 80cm and on the upper slopes 350cm, the temperature is 0 degrees, the runs are ICY and the piste is HARD.

2. The information for the JACKSON HOLE resort in the UNITED STATES is no longer required. Delete the record.

3. Some corrections need to be made to the original data:


a. The lower slopes at Wengen, Switzerland should be 25 not 10cm


b. The information relating to the runs at Bormio, Italy should be icy not patchy.


4. Sort the file into alphabetical order of RESORT.


5. Sort the file into descending order of TEMPERATURE

Using Searches

6. Search for all records showing GOOD conditions on the runs.



7. Search for all records showing temperatures over 4 degrees.


8. Search for all records for FRENCH resorts with snow on the upper slopes of 350cm or more.

9. Sort one other field of your choice.

10. It is now your chance to choose a skiing holiday! Decide what your criteria are (at least two), e.g. I want to go to Italy, to a ski resort with slick runs.