I have to apologize first, as I had this working at home, to some extent. Not well. I have to submit a printout of grades, today, if possible, and I've been struggling with it. Can't find the cookbook formula! (I would like to use the \footnotesize feature also). So far I've had to go through each table, deleting long words, and deleting some fields. WOuld rather have some way to do it as is.
How to do this? The table should break over two pages. It would seem to me that some combination of sidewaystable and longtable might do it.