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.

Create a backup of the database

Create a backup of the database

From the course: Access 2019: Queries

Start my 1-month free trial

Create a backup of the database

“

- [Instructor] There are four additional types of queries within Access, collectively called action queries. We can take a look at them by going to the Create tab and then starting a new query in design view. I'll simply close out of the show table window, here. The action queries are the Make Table, Append, Update, and Delete queries. You can see that they all share the same exclamation mark in their icon. We're going to take a look at these over the next few videos, starting with the Update query. Now, action queries differ from everything else that we've worked with so far in one key area. They actually modify your data tables. In case that's not clear, all the queries that we've run up to now simply presented your data, rearranged and reformatted, in temporary tables called Record Sets. All of the actual data tables within your database have remained unchanged. Action queries throw that behavior out the window. They permanently modify your data. This can be really powerful when…

Contents