Also note:
"
Exit" (Student Database), "
Day & "
Time" (Class Details) are
reserved words in Access and
shouldn't be used for object names.
Should
not use spaces in object names. Object names include Field, Table, Query, Form, Report and Module names.
I use a suffix of "_PK" for the primary key field name and "_FK" for the foreign key field name. Example would be "StudentID_PK" and "StudentID_FK"
It is also helpful to use a
prefix to name objects.
Example:
"
tblStudents" (your "Student Database" is actually a table),
"
frmStudents",
"
qryStudentsActive" and
"
rptStudents".
See
Problem names and reserved words in Access
Microsoft Access Tables: Primary Key Tips and Techniques (<<-- read at least twice
)