Student Database Populate and Query Assignment
You created an Access Database on students that involved
courses and grades under notes and assignments for week #6. Now I want you to populate the database with
data. You should have at least 5
students, 3 majors, 5 courses and your students should take a variety of
courses.
Now you need to query the database:
- Produce
a query showing all the students in one particular major. I want to see the student name and the
major name.
- Produce
a query showing all the courses that each student is taking. I want to see
the student name, the course name and the grade the student got in the
course.
- Produce
a query showing all students in a particular major with a GPA > 3.
- Produce
a query showing all students that students took where their grade was an A
or a B.