I've never really used access or SQL too much, so I need some help. I was told to use an Intermediate table to organize information, but I have no idea what that is. Can anyone help me out? >_<

This question is out of context so it is hard to determine what you are looking for. If this question originated from a suggestion to normalize your tables, the intermediate table is usually called a relation table and is used to relate one table to another in a many-to-many situation. For example to relate students to classes, you would need a third table which might be called tblClassRoster. It would contain the StudentID and the ClassID as a multi-field primary key. It would probably also contain a field to hold the final grade for the class.