Access — Transfer and Modify Data from Table to Table

I am populating a table through a form, and I would like to figure out how I can take the results from the form and perform a calculation on the data and store it in a new table. I’m looking for this all to happen automatically. Is it possible?