How to sanity check updated records?

[BittenApple]

Hello team,
I update the tables, I wonder how we know the update is done correctly. What are the methods that we verify the update is done perfectly.
Regards,
appapp

[HansV]

That depends on what you are updating. Without knowing more details it's impossible to provide recommendations.

[Mark L]

What exactly are you worried about? That Access somehow made a mistake? Considering that is pretty unlikely, you'd be talking about checking the validity of the data you submitted. But that should be done BEFORE you update, not after.

[BittenApple]

Hans, Mark
When I update, I am always worried if the table is updated correctly. Sometimes, I copy and paste the values and brings into excel and do some quality check on it.
Regards,
appapp

[HansV]

Again, without knowing what you are replacing with what, it is not possible to give suggestions.

[Mark L]

appapp,
You really didn't answer my question. What exactly are you worried about? Are you worried that Access did something wrong or are you worried that you may have done something wrong?

[BittenApple]

Hello Mark,
I am worried about both; I am worried that I might have left a field in my query and as a result that field don't get updated.
Regards,
appapp

[Mark L]

This is why you test. Once you have verified your query is working properly, you don't need to continuallyo check to see if tables got properly updated.

[BittenApple]

Mark,
"Once you have verified your query is working properly"
What is your point of verification? Should I check that I have all the fields that I need to update?
Regards,
appapp

[HansV]

The idea is to test with a few records:
- Create a source table with a few records.
- Duplicate the source table.
- Run the update query.
- You can now open the updated table and the copy of the original one side by side.
- Compare the contents and check that the update has done what you wanted.

[BittenApple]

Hans,
Thanks,