World+Cup+Winners

Download the database file World Cup Winners.

Use the database to answer the questions below:

1. Who won the World Cup in 1986? 2. Who won the World Cup in 1938? 3. Where was the World Cup held in 1990? 4. Where was the World Cup held in 1958? 5. How many times has the World Cup been hosted in Europe?
 * Searching**

6. Who have been the host nations when the World Cup has been hosted in North America? 7. When was the World Cup hosted in Asia? 8. When did Argentina win the World Cup? 9. How many times have Brazil won the World Cup? 10. Who was the host nation when Spain won the World Cup?

11. How many teams took part when England won the World Cup? 12. What was the score when Sweden were runners-up in the World Cup? 13. How many World Cup finals have Germany (including West Germany) won? 14. How many World Cup finals have Germany (including West Germany) lost? 15. When did France appear in a World Cup final?

16. How many times has the World Cup been decided after extra time? 17. Which countries have lost the World Cup on penalties?

18. Sort the database in alphabetical order of winners. Where a country has won more than once, sort in order of Year.
 * Sorting**

19. Add 2 extra fields to the database: Flag - an image of a flag of the host nation Link - a web link to the Wikipedia national team page for each World Cup winner. Links [|can be found here]
 * Adding Fields**

20. Change the layout by:
 * Changing the Layout**
 * Changing field text colour, field text style etc
 * Rearranging fields on screen
 * Adding a World Cup background image (this will appear on all records)

To do this, go to File -> Manage Layouts -> New Layout/Report...