Access Assignment using Relations and Queries:

Your assignment is to develop a simple student record keeping system. You need to keep the following:

Student id

Student name (store last and middle initial and first in separate fields)


Name of the major

Date enrolled

Courses taken

Semester course taken

Grades on the courses taken

Name of the course

Assignment: Note that you can combine things. For example the query using 2 tables can also use the AND and the concatenation etc. LABEL things so I know what you did.