So I've come pretty far along on my Gradebook Database. I've used join tables but they oftentimes aren't functioning as expected. The Gradebooks is usable at this point but has several issues.
The first is...I'd like to be able to get Class Averages, Max, Min for Assignments to go on this Tab - Course Grade Breakdown
Here's the Database Relationship Diagram:
Here are a couple of images that might help:
and one last image:
The tiny Class Assignments window in the top right corner is there because I can't figure out a way to automate Assignment information - DateDue, Points, Etc.
Any help would be greatly appreciated.