Olympic+Games+Host+Cities+Database

Download this database which lists the details of the all of the host cities of the modern Olympic Games.



Use the Find mode to answer the following queries

1. In which city were the 1972 Olympic Games hosted? Explain how you used Find mode to get this answer.

2. In which city were the 1948 Olympic Games hosted?

3. In which country were the 1920 Olympic Games hosted?

4. What was the demonstration sport in 1912?

5. Which city introduced Roller hockey as the demonstration sport?

6. How many times have the Olympic Games been hosted in the USA? Explain how you used Find mode to get this answer.

7. How many times have the Olympic Games been hosted in the London?

8. Sort the database by country. Write down the names of all countries which have hosted the Olympic Games more than once.

9. Sort the database by country. Where a country has hosted the Games more than once, sort the data by year. Explain how you did this.

10. Which countries hosted the Olympic Games before 1912 (try <1912)

11. Which country will host the Olympic Games after 2012 (try >2012)

12. Which cities hosted the Olympics between 1948 and 1972? Explain how you found this answer

Extension
1. Choose one demonstration event you have never heard of. Find out about, and write a short description explaining what it is.

2. Why were there no Olympic Games in 1916?

3. Why were there no Olympic Games in 1940 or 1944?

4. Investigate a story of interest from one of the early Olympic Games. Write a short paragraph about it.

Help
How do I perform a find between 2 values?

1. Do a search for the first value in the usual way

2. Click the **Find** icon to go into find mode

3. Enter the second value in the search field (but don't hit enter)

4. Go to the **Request** menu and choose **Constrain Found Set**