Prepare a userform where the input fields are First Name (text) Last Name (text) Student No (unique number) GPA (decima
Posted: Thu Jun 02, 2022 8:32 am
Prepare a userform where the input fields are
First Name (text)
Last Name (text)
Student No (unique number)
GPA (decimal number between 0.00 and 4.00)
Number of Credits Taken (integer between 0 and 150)
In the form there should be Save Data, Close Form buttons
Prepare a second form (reachable from the first form) where
there are summarizing fields where you calculate the
min/max/average GPA of the class room.
It should also show the top 3 students ranked with respect to
their GPA
You can display the number of credits taken by a student when
you enter the student no (so there will be a field where you enter
student no. And when you click it, it should display the credits of
the corresponding student)
Fill with at least 10 student data (you can randomly give
numbers and names…)
First Name (text)
Last Name (text)
Student No (unique number)
GPA (decimal number between 0.00 and 4.00)
Number of Credits Taken (integer between 0 and 150)
In the form there should be Save Data, Close Form buttons
Prepare a second form (reachable from the first form) where
there are summarizing fields where you calculate the
min/max/average GPA of the class room.
It should also show the top 3 students ranked with respect to
their GPA
You can display the number of credits taken by a student when
you enter the student no (so there will be a field where you enter
student no. And when you click it, it should display the credits of
the corresponding student)
Fill with at least 10 student data (you can randomly give
numbers and names…)