From the course: Access 2019: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Update data with a query

Update data with a query

From the course: Access 2019: Queries

Start my 1-month free trial

Update data with a query

“

- [Instructor] The update query is one of four action queries in Access. Using it, we can create a selection of our records that all require a specific update or a modification to their data, and then update all those records throughout the entire database. The update query will not only breeze through the task, it'll prevent any data entry errors that typically crop up when manually modifying large amounts of records. Before we being, though, if you haven't already done so, please take a moment and review the previous video on creating a backup of your database. For this example, I'm going to open up the Employees table and scroll over here to the far right. You'll notice that we have a column for the employee's salary. What I want to do is add a five percent cost of living increase to all the employees' salaries. In other words, I want to permanently increase the salary for each employee by five percent. Let's go ahead and close down the Employees table and we'll start a new query…

Contents