I am not sure I understood your question, are you trying to update a table whenever you have an update in another table?

You can do this using a trigger in all RDBMS, but Access may not be able to do it.