In this homework, you will generate a database with some basic data about most of the larger countries in the world. Please do not be upset if you do not see your favorite country in the database; I had to eliminate many countries for which complete recent data were not available.
Q1. Make a database called "countries.mdb" that contains a single table "COUNTRY". The fields in this table should be:
Note that total area and land area are different, because land area does not include lakes, rivers, and coastal waters claimed as part of the country's territory. GDP is measured in US dollars per year, and Oil consumption in barrels per day.
Once you have saved this table, close it and select it in the "tables" pane
of the database window, click the "Analyze" button on the toolbar (to the right
of the little "W" icon), and choose "Documenter". Check "COUNTRY" in the
"Tables" pane, and click OK. An "object definition" window should then
appear, containing a report. Use File →
Print to print this report, and hand it in.
Q2. Download and save the file "countrydata.txt" from the class website. Then
load it into your "COUNTRY" table by selecting File →
Get External Data → Import, selecting "Text
(*.txt, *.csv, ...)" under "type of file", selecting the file, and clicking "OK". The
"wizard" should ask you some question to which the default answers should
suffice, except that you should select the existing table "COUNTRY" to import
into, rather than letting Access create a new table. View the resulting table, select File →
Print, and just print the first page, and hand in this printout.
Q3. Using the form wizard, or any other method you like, construct a form for this table that looks approximately like this:
Make sure the form has a header
like "Country Data" at the top of the form. With the form visible, select File
→ Print, and print and hand in just the first
page.