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:

1. Produce a query showing all the students in one particular major. I want to see the student name and the major name.
2. 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.
3. Produce a query showing all students in a particular major with a GPA > 3.
4. Produce a query showing all students that students took where their grade was an A or a B.