Criteria, Extract Data From Tables

I have imported several Excel files into Access to create tables in the database.



I teach online and basically I need to know how to extract certain bits of data from each table and put them together.



For example:



Table #1 is my student roster list and contains the fields: Firstname, LastName, SchoolName, and several other fields.



Table #2 is a list of schools throughout the state with fields such as: SchoolName, Registrar, ContactPerson, and so on.



There are several other tables involved but I’m trying to make this question as simple as possible and if I can get this question answered, I think I may be able to figure out the rest.



I would like to print a report out for each individual student that will include the school name from Table #1 and match it with the same school name in Table #2 and then extract the pertinent school information from Table #2 for that school.



I have more than one table with a list of schools. Should I name each field that pertains to the school name with a unique name?



To clarify….



Table#1 can have the same school name listed any number of times because some of the students attend the same school.



Table #2… Each unique school name will be listed only once.





These Excel files come to me regularly as they are updated and I am trying to find an easy way to extract the data that I need.



Can someone please tell me how to write this query?



Thanks so much for your help!