Complete the following tasks using Microsoft® Access®:
- Create a database consisting of two tables.
- Name both tables.
- Create fields for each table. The first table must contain the following fields:
- Student ID number
- First name
- Last name
- Gender
- Phone number
- Address
- Major
- Minor
- The second table must contain the following fields:
- Student ID number
- Course
- Letter grade
- Establish a primary key for each table.
- Create a relationship between the two tables.
- Set appropriate properties for all fields.
- Enter at least five mock student records in the first table. In the second table, enter at least three courses for each student listed in the first table.
- Create a report containing student ID numbers, first names, last names, courses, and letter grades for all students.
- Create a query to search for students who received an A in a course. Display student ID number, first name, and last name in the query.