Assignment 5

Due Date: 11/26/2001

Requirement:

Printout of code, floppy disk containing source code and executable. source code cannot have more than 12 variables.

Problem:

            An Access database project5.mdb contains a table called Students with the following fields

            Field Name              Field Type    Field Size   

            StudentID                 Text                 5

Grade1                      Integer

Grade2                      Integer

Grade3                      Integer

Grade4                      Integer

FinalAverage                        Double

FinalGrade                Text                 1

The StudentID, Grade1, Grade2, Grade3, Grade4 have values

            Create a program that performs the following on the above database

Updates the FinalAverage field = (Grade1+ Grade2+Grade3+Grade4)/4

Updates the FinaGrade field based on the following

            A – 90 to 100

            B – 80 to 90

            C – 70 to 80

            D – 60 to 70

            F – 0 to 60

Print out the following in a text box

            The number of A’s, B’s,C’s, D’s,F’s           

            The number of students with each grade(if count is > 0)

            Example

84 - 1

83 - 1

80 - 3

79 - 2

77 - 2

76 - 3

75 - 3

74 – 2

The count of the number of students with an average greater than the class average

The count of the number of students with an average less than the class average