Microsoft Access 2007 Sample Database

Geographical Data - Countries, Cities and Provinces

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.

Table Relationships

The table relationships described above are illustrated in the relational diagram shown on this page.

Downloading the Database

The database is available as a free download at this link: MONDIAL.accdb. The file is stored in Microsoft Access 2007 ACCDB format.

Acknowledgements

The data contained in this database is drawn from the MONDIAL project, with permission.