go to the Access MVP home page

Reference Database
compiled by Crystal

thanks to Arvin Meyer for setting up this site and giving Access MVPs a place to share with others.
 

Download Reference_Zips_Countries_States_PhoneCodes_Airlines_Airports__2K_MDB.zip (1.8 mb)  

Access 2000 database contains these tables:
  • Zip Codes &mdash Zip, City, State, County, Latitude, Longitude -- US Zips (42K+ records)
  • Countries &mdash Country Codes and Country Names (250 records)
  • States &mdash State Abbreviations and State Names for the United States, Canada, and Military (72 records)
  • PhoAreaCodes &mdash Telephone Area codes for the United States (380 records)
  • PhoIntlCodes &mdash International Dialing codes for Phone calls (230 records)
  • Airlines &mdash Airline Name and IATA codes for Airlines around the world, includes base Country and airline note (535 records) - updated Aug 6, 2009
  • Airports &mdash Airport Name and IATA codes for Airports around the world, includes City and Country (and State for USA) (2,750 records) - updated Aug 6, 2009

Free Book on Access: Access Basics

Free Tutorials: Video Tutorials

for information on private programming and training, or if you have comments and ideas, I'd love to hear from you

© Copyright 2009 Crystal Long.  All rights reserved.
Last Updated:  August 6, 2009