Microsoft Access 2007 Sample Database

Software

Updated December 11, 2018

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 articles on our 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.