Final answer:
An update query is used when a user needs to modify data, such as adjusting product prices in a database due to supplier cost changes.
Step-by-step explanation:
You use update queries in Access databases to add, change, or delete the information in an existing record. You can think of update queries as a powerful form of the Find and Replace dialog box. You cannot use an update query to add new records to a database, or to delete records from a database.
One example of a situation that calls for an update query is when a user wants to modify the prices of products in a database due to a change in supplier costs. An update query would allow the user to change the price field in the products table for all or specific products, depending on the criteria set for the update. It's an efficient way to alter multiple records at once without having to edit each one individually. This operation is often used in business or retail settings where price adjustments are common due to market changes or new business strategies.