Easiest thing to do may be to get something like mysqlman, perlmyadmin, phpmyadmin, all of which are cgis that make it very easy to handle your mysql dataases.
From there, there are ways of getting the data dumped quite easily into a file that can be loaded into Excel or Access. (CSV, TAB-delimieted, etc)
The second question is tricker, you may need to do a table join and a sneaky sum trick.
From there, there are ways of getting the data dumped quite easily into a file that can be loaded into Excel or Access. (CSV, TAB-delimieted, etc)
The second question is tricker, you may need to do a table join and a sneaky sum trick.