Microsoft Access 2007 Sample Database

Software

Updated March 30, 2017

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.