can u set up ur database to automatically run a query each time you add or edit a record?

No, this is called a "trigger" in other RDBMS' and Access does not support them. Similar functionality can be performed via a form. However, unless you have totally secured the app so that there is no way to update the table without using the form, data anomolies could be introduced.