To avoid a mistake when using an update query that includes making calculations on a field,what is one thing you can do to prevent losing the original information?
A)Add an additional field with the original figures.
B)When you run the query,just undo if you question the new figures.
C)Rerun the query to make sure the figures have updated.
D)Backup the database after you have run the query.

Question

Quizplus · Accepted Answer

Adding an additional field with the original figures ensures that the original information is still available even after making calculations on the original field. This allows for easier comparison and verification of the new figures.

To Avoid a Mistake When Using an Update Query That