Updation of records in db

Hello all

Im creating a fantasy football site where each user creates their team from a
list of players within the premiership league.This I can do fine the only
thingim worried about is that I will need to update each of the records to give
people their points each week.

Im using Microsoft Access to make my database(it's only for a college
project)and I'm wondering if there's an easy way to add in the points than
creating a query for each player.

The players are stored in a players table. And the users will have these codes
in their table.The fields in the users table are:
UserID
GK_1_ID
DF_1_ID
DF_2_ID
DF_3_ID
DF_4_ID
MF_1_ID
MF_2_ID
MF_3_ID
MF_4_ID
ST_1_ID
ST_1_ID
SUB_GK_ID
SUB_DF_ID
SUB_MF_ID
SUB_ST_ID
TotalPoints
I also have a table that holds the scores of each week for the user.

Is there an easy way to add the points up-I will hopefully just be adding
points to the players table and then it will automatically add it to each users
TotalPoints.Is this possible and if so how?

Thanks for your help,
Drea