If I am correctly a query gives the information for you?
Then create a query or edit your existing query for inserting the values into a table. To make it more fancy you can build a form with an event like onload, what is checking out if the insert is done for that week and if not then do it. Even possible to do that with several weeks in one time if you did not use the database for more then a week ;)
Access can do almost anything :)) Just develop your skills and enjoy the possibillities