Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
There are four additional types of queries within Access collectively called action queries. We'll take a look at them over the next few movies starting with the Update query. Action queries differ from everything else that we've worked on so far in one key area. They actually modify your data tables. In case it's not clear, all of the queries that we run up to now simply present your data, rearranged and reformatted, in temporary tables called Record Sets. All of the actual data tables within your database remained unchanged.
Action queries will completely throw that behavior out the window. They will permanently modify your data. This can be really powerful when used appropriately or it can make a really big mess real fast. So before we jump in, I want to you take a moment to really let that sink in and I also want to walk you through the steps that are critically important in making a backup of your database. We'll go up to the File tab and select Save and Publish. Under the Save Database As, we'll choose Back Up Database. When you press the Save As button, Access asks us where you want to save that.
You'll notice that it appended today's date to the file name. We'll go ahead and say Save and that's it. Access has backed up our database into our exercise files folder. Action queries are both destructive and irreversible, but don't let that prevent you from making use of them. Now that we're protected from any unfortunate mishaps, we can move forward.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90349 Viewers
80 Video lessons · 137842 Viewers
59 Video lessons · 56582 Viewers
52 Video lessons · 70196 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.