Is it possible to have a command button that will update your database when clicked.

EX. You enter some info into a textbox, then click the command button, the button then takes the data in the textbox and updates the correct table/query in the database?

more advanced coders:
if it can do this, can it also make a sound on the PC that the database is on, warning the user the database has been updated?