The file GradeData.zip contains the database GradeData.mdb.
This database contains the table DataTable, which contains these fields, all of type Text:
ID Last First CourseNumber CourseName ProfName CreditHours Grade
Your application should load the IDs of the studentsinto a listbox. Then when an ID is selected and the Submit Button is clicked, the last name, first name, and GPA of the student should be displayed. The GPA is calculated as total grade points weighted by credit hours divided by total credit hours. Grade points are assigned as follows:
| Grade | Grade Points |
|---|---|
| A | 4 |
| B | 3 |
| C | 2 |
| D | 1 |
| F | 0 |