Use an update query in Access desktop databases to update or change the existing data in a set of records.

You use a make table query when you need to copy the data in a table, archive data, or perhaps save query results as a table. If you need to change or update part of the data in an existing set of …

How to update data in more than one table. Other videos in this course This video is part of a training course called Use update queries to change data in Access 2013.

You use an append query when you need to add new records to an existing table by using data from other sources. If you need to change data in an existing set of records, such as updating the value of …

You can use an Update query to change a single value in a multivalued field to another value. In this example, you want to update the AssignedTo multivalued field to replace "Kelly Rollin" with "Lisa Miller."

You can nest this query inside of your main query by using a subquery. You can write a subquery in an expression or in a Structured Query Language (SQL) statement in SQL view.

This section explains how to use an update query to delete individual fields from tables. Remember that running an update query to delete data will change the existing values to either NULL or a zero …

In this article, learn how to compare two Access tables by using query joins, or by using a field as a criterion.

Although you can use the DLookup function to display a value from a field in a foreign table, it may be more efficient to create a query that contains the fields that you need from both tables and then to …

Use the Linked Table Manager in Access to manage external data sources and to refresh, relink, edit, or delete linked tables due to changes to the data source location and table name or schema.