Trust me I get it, I know how queries work. That really does not answer any questions. If you want help, please answer the questions instead of telling me how you think Access works.
WHY CAN YOU NOT HAVE A SINGLE PK IN THE STUDENTS TABLE AND A FK IN THE NOTES TABLE? What is the purpose of the composite keys.
ok now students have PK and studentsnotes have nothing no FK or PK
what's next