First of all, it is a really bad idea to use the student name to relate the tables. What if the student name changes, or was previously mistyped and is corrected, or is the same as somone else. All these scenarios will cause you many problems.
Second, while you can find all the related records from each related table, it is not easy to display all of these found records on one layout. One way I have done it in the past is to create a layout with portals showing related records from each table. The user simply switches to the special layout and can see related records from every table. Would that work for you?