Скачать или смотреть Update Query in MS Access - Office 365

Update queries in MS Access are used to add, change or delete information in an existing record. You can not use an update query to add new records or to delete records from a database. An update query is a type of action query that makes changes to several records at the same time. As a best practice when creating an update query first create a select query that identifies the records that you want to update then convert that query to an update query that you can run to update the records. This will help to avoid making incorrect updates to records. You can use any expression with an update query, ranging from mathematical functions to string operations.