The Update query is one of four Action Queries in Access, and it can be used to dynamically update information across the database. In this movie, Adam creates an Update query to increase the base salary for the H+ Sport employees, and demonstrates how to selectively target updates using the same query criteria explored earlier in the course.
- [Voiceover] 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 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 begin, if you haven't already done so,…please take a moment and review the previous movie…on creating a backup of your database.…If I take a look inside of my Employees table and…scroll over here to the far right, you'll notice that we…have some information on salary.…
Well let's say I want to apply a cost of living increase…to all employees' salaries of 5%.…Essentially what I want to do is permanently update…these salaries to be increased by that 5% raise.…Let's go ahead and close the employees table and…we'll create an update query in design view…in order to tackle the task.…I'm going to choose the Employees table…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.