1. I need to know how to update the field list of the query after
adding a new field into the table and the query?
2. I need to know how to update the records table after adding
calculated filed?
1) open the query and add the field to the grid by double click or drag.
2) don't store calculated fields. calculate only when you require a view (say on a form) or in a report.
