Complex Query with many tables

[Guest_imported]

I have created a databse in access for the purpose of finding information about the university program.
I have the following tables :
CLASSROOm
ClassroomName(pr. key)
Building
Classroom Type
Floor
Capacity

TIME
Time (pr. key)

COURSES
ID (pr. key, autonumber)
Course
CourseID

SEMESTER
Semester(pr. Key)

PERSONELL
PID (Pr. key)
Surname
Title
DepartmentCode

DEPARTMENT
DepartmentCode (pr. key)
Departmnet
School

USE OF WINTER SEMESTER
ID (pr. key)
DepartmentCode
Department
Semester
CourseID
Profesor1
Professor2
Professor3
Professor4
Professor5
Professor6
Day
Time
ClassroomName

I would like to tell me how to create the query that answers which classroom is free (available) at a specific time and day?

 

[SouthwestNut]

If I understand the problem correctly, you have 2 different types of tables: Reference and Dynamic. My definition of a reference table is one where you refer to it but rarely edit/add to it. "Time" seeems to be a reference table for example.

It seems that you have a number of many to many relationships and you need to create tables that break them apart into 1:M relationships. For example Classroom and Courses are M:M. You would need to create a junction table that would break them apart. It would have 2 fields (ClassroomName and CourseID) and the primary key would include both fields.