I have students who pay a certain rate per hour of tutoring and make payments from time to time to cover their charges. Up until now I have been using a separate Google Sheet for each student like this:
Date   Hours   Payment   Balance
11/3/2019  1.00      -30
10/11/2019 1.50      -$75.00
11/17/2019 1.00      -$105.00
11/24/2019 1.00      -$135.00
11/24/2019  $135.00     $0.00
11/28/2019 0.50  -$15.00
But I want to split it up into separate Student and Activity tables in one Access database. The problem is keeping a running balance. What I would do in my old database language would be to keep  a balance field in my student table and update it  as I save each activity record, and mark that record as posted, so if if I have to go back and make a correction, it won't double post. If I would have to make a correction later I would read the original amount into a holder variable, check it against the new amount and change the balance field in the Student table by the difference bet. the new amount and the old amount. Is this the best way to do it Access? Can you think of a simpler way? Do you already have a video that covers this?