Microsoft Access 2007 Sample Database

This Microsoft Access sample database provides tables containing information on the world's countries, cities, and provinces. It is used to illustrate examples for a number of the articles on the About Databases site and also provides a good sample for students, professionals and others who are learning Microsoft Access.

Database Tables

The database contains three tables. The Country table contains the following fields:

Country Name: the name of the country
Code: a short alphabetic code used to reference the country. This field serves as the primary key for the Country table.
Capital: the name of the country's capital
Province: the province of the country's capital
Area: the total area of the country
Population: the total population of the country

The City table contains the following fields:

ID: a numeric identifier used as the table's primary key
City Name: the name of the city
Country: the country code for the city. This field is a foreign key to the Code field in the Country table.
Population: the population of the city
Longitude: the longitude of the city
Latitude: the latitude of the city

The Province table contains the following fields:

ID: a numeric identifier used as the table's primary key
ProvinceName: the name of the province
Country: the country code for the province. This field is a foreign key to the Code field in the Country table.

Population: the population of the province
Area: the total area of the province
Capital: the capital of the province
CapProv: the name of the province where the capital exists. Due to unique circumstances in some areas, this field may differ from ProvinceName, although it is often the same.