ITEC 3335
Database Development
Fall 2017
Homework #2

MS Access Query

Use MS Access Query Design tool to answer the following queries for the database world.accdb. Take a screenshot of the Query Design as the answer for each of the following question.

[1] Provide the name, surface area and population of all countries with a population more than 100,000,000.

[2] Provide information of all countries in North America in the following format.

(3) List the names of the countries with English as a language, together with whether English is an official language, and the percentage of people with English as the primary language. List only those countries with a percentage of English as the primary language of 30% or above.

(4) List the names, populations, countries, and continents of cities in which English is an official language. List only those cities with a population between 900,000 and 1,000,000.

(5) List the names, countries and populations of all cities in the following manner:

...

Note that the display names of the columns are 'Country', 'District', 'City' and 'City Population' respectively. Furthermore, the result is sorted in the order of country names, city names and then the descending order of city populations.

(6) (Bonus) List the names, populations and numbers of cities of all countries in the following manner:

Submit the homework through Blackboard.