I have several tables within a base for example Student_Details, Course_details, Job_details. I would like to be able to run reports where for a given student I could see all the courses they attended, or how many students who attended a course went on to get a job.
The tables listed above are linked so that the the student name is the link between each table.
I guess the main questions, can I do this without using Pivot Tables? If I do use Pivot tables can you use data that is across multiple tables?