How to calculate points and places in Access?

Question

Microsoft Access

Gentlemen, we need advice or resources with materiel.
In a sports institution, you need to arrange the calculation of points and places of participants according to the standards in Microsoft Office Access.
More details:
There is a database of participants (Pay number, full name, date of birth, etc.), manually entered
There is a base of standards for competitions, manually entered
There is a competition database in which the result is manually
entered checked with the standards, counted and set points?

Answer 1

If I understand everything correctly, then you can create an additional field in the database of participants that contained the result, then make a VBA module that calculated the result for each participant according to the standards and wrote it down in the field.