Activity 2 - Africa Database project
Create a database: Africa Database
This database will have 2 Tables:
Table 1
Name: Region
This table will contain the following fields: Code, Region
This table will contain the following Data:
This database will have 2 Tables:
Table 1
Name: Region
This table will contain the following fields: Code, Region
This table will contain the following Data:
Table 2
Name: Country Details
This table will have the following fields: Country, Capital, Population, Currency, Main Language, Region, GDP per Capita,
Research 15 African countries and add records for each country.
There must be at least 1 country from each region.
Note the when entering the region ensure that only a N, S, E, W or C can be entered.
Use Query to produce the following reports (give each report an appropriate title):
Name: Country Details
This table will have the following fields: Country, Capital, Population, Currency, Main Language, Region, GDP per Capita,
Research 15 African countries and add records for each country.
There must be at least 1 country from each region.
Note the when entering the region ensure that only a N, S, E, W or C can be entered.
Use Query to produce the following reports (give each report an appropriate title):
- An alphabetical list of all countries. The fields on this report should be Country, Capital, Population and GDP per Capita.
- A list of all Central African Countries.
- A list of all African countries in which English is spoken.