Reference no: EM13994841

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.