Prepare student database

[MAMU]

How to prepare Student Database purposeful for posting their results so then they may register online and view them while am admistering the whole system? (FOR ANY EXCELL EXPERT MEMBER PLEASE HELP): Which array formula may i use prepare student point and division where:- range of marks 74-100=A 60-74=B+ 50-59=B 40-49=C 30-39=D 20-29=E 0-19=F To get sum of POINTS A=1,B+=2,B=3,C=4,D=5,E=6,F=5. Division one starts with point 7-17, Division Two point 18-24, Division Three point 25-31 Division four anyone with two "D" or one "C" Division Zero score less than one "D" Note: points should sum for only 7 subjects the student did well in 9 subjects. There are some gaps in the range of those 9 subjects as others may sit for 8 subjects, how to overcome n/a error? Thanks in advance

[Dal Jeanis]

(1) Your inverted point structure is going to give you problems if your students have less than 7 subjects in the database. It would be smarter design to have A be 6 points, B as 5, and so on. Division One would be 42-32 points, Division 2 would be 31 - 25 points, and so on.
(2) You are giving "worse" points for E than F. Why?
(3) According to your rules, some students will belong to both Division Zero and one of Divisions One-Three. Or belong to both Division Four and one of Divisions One-Three. Did you mean that?
(4) The question of registering online and viewing results is unrelated to the question of calculating the scores. You can have a database that calculates the scores, then publishes the results to literally any online database access method you choose.
(5) A custom update query can translate marks into both grades and points. For your application, I would go against the standard rules and store that calculated information in the table, just to avoid the complication of the later select queries. (Lots of skilled DBA-types would disagree, but you are not a skilled DBA, and this will avoid errors.)
(6) Another update query with the "TOP" keyword can get you the best 7 for each student, and you can update that student's record with the sum of their top 7 points results. (Again, this violates professional convention, but it's the right decision for you, in my opinion).
(7) Finally, an update query can take their total points and assign them to a Division based on the total points.

Overall, this is a pretty simple system. Assuming, of course, you have any Access experience at all.

Start by posting an initial design in the database design forum to get some feedback.