How To Software Sample Database in Microsoft Access 2007 Geographical Data - Countries, Cities and Provinces Share Pin Email Print Andy Crawford/Getty Images Software Databases Documents Spreadsheets Presentations Desktop Publishing Graphic Design Animation & Video by Mike Chapple An IT professional with more than 10 years of experience in the fields of databases and cybersecurity. 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. 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. Acknowledgments The data contained in this database is drawn from the MONDIAL project, with permission. Continue Reading