Assessment $8-1($VB$.$NET$)$

A teacher maintains a database containing two tables$-$Students and Grades. The Students table has three fields: studentID, lastName, and firstName. The Grades table has four fields: studentID, firstExam, secondExam$,$ and finalExam. At the beginning of the semester, the Students table is filled in completely with a record for each student in a class, and the Grades table has a record for each student that contains only the student's ID number. $($Note: The database is contained in the file Assessment $81.$accdb.$)$ Write a program that allows the instructor to record and process the grades for the semester. The program should do the following:

a$.$ Use a navigation toolbar to fill the Grades table.

b$.$ After all grades have been entered, display a DataGridView control showing the name of each student and his or her semester average. The semester average should be calculated as:

$($firstExam$+$secondExam$+2*$finalExam$)/4.$

Grade Book $14$

$5$

of $5$

Display Student Grades

student ID:

LS$-222333$

first Exam: $$

$$

second Exam: $$

$$

final Exam: $$

$$

$\backslash$table$[[$fullName$,$semGrade$],[$Al Jones,$85\mathrm{.}0000],[$George Jackson,$93\mathrm{.}0000],[$Lauren Smith,$94\mathrm{.}0000],[$Grace Green,$77\mathrm{.}0000],[$Fred Adams,$85\mathrm{.}0000]]$