Creating Queries in Access 2010
- 6/15/2010
- Introducing Query Types
- Creating a Query Using the Query Wizard
- Editing a Query in Design View
- Using Criteria to Focus Query Results
- Introducing Operators
- Using Queries to Calculate Values
- Creating a Parameter Query
- Finding Duplicate Records
- Finding Unmatched Records
- Writing Query Results to a New Table
- Creating an Update Query
- Creating a Crosstab Query
- Finding the Largest and Smallest Values in a Field by Using a Query
Creating an Update Query
One exciting aspect of business is how quickly things change—of course, it can be difficult to keep track of all those changes! One useful task you can perform with an update query is to modify values in a table to reflect changes in your business environment. For example, if a supplier increases prices by 5 percent, you can create an update query that moves through your Products table and updates the records for that supplier’s products.
Update Table Values with a Query
Open a query in Design view.
Click Update.
In the Criteria cell of the column you’ll use to select the records to update, type the expression used to select which values should be updated.
In the Update To cell of the column that contains the value to be updated, type the expression used to update the values.
Click Run.
See Also
For more information about ensuring that table data is updated to reflect changes in a related table, see Enforcing Referential Integrity.