First off, as an FYI, you can easily attach a zip file (or I think even an mdb) directly to your thread. Most people prefer that so we don't have to worry about a secondary site with viruses or anything.
Secondly, this wouldn't happen to be a homework problem would it? I think I've seen about 5-6 threads just at the end of this schoolyear alone with a question almost identical to this one. This is a pretty classic end-of-the-year assignment after all, and I see this one popping up every year in this forum around this time.
I looked at your database.
1. your location table is built incorrectly. You really should have an autonumbering ID as your primary key, and then a text box as your location description. Using a text datatype as a primary key is not the best of setups.
2. What I assume is possible is that multiple teachers could teach the same course, correct? In that case, you'll need a junction table that links many teachers to many courses.
Once your table structure is correct, then you can work on your queries to achieve your goal.