A Microsoft Access query enables us to choose which field from which tables we want to be shown - http://databasementor.com/basic-ms-access-lessons/cds-database/Query-Multiple-Tables/
