Could anyone give me the proper syntax for executing a SQL Update Query in VBA in an on_click event?

Maybe like a step-by-step explanation?