The database UN.accbd has the single table Nations that contains data for the 193 member countries of the United Nations. The fields for the table are name, continent, population, and area. (Population is given in millions and area in square miles.) Use the United Nations database in the following exercise. Some of the records in the table are shown below:
Using Visual Basic, write a program that displays the names of the continents from the Nations table in a list box. When the user clicks on a continent’s name, the countries in that continent should be displayed in two other list boxes. One list box should display the countries in descending order by their population, and the other should display the countries in descending order by their area. See the figure below for an example.
Suggested Control Names and Attributes:
|Name Property||Text Property||Control Type||Notes|
|frmUnitedNations||United Nations||Form||Holds Controls|
|lstContinents||ListBox||Displays list of continents|
|lstByPop||ListBox||Displays list of countries in order of descending population|
|lstByArea||ListBox||Displays list of countries in order of descending population|