Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information. The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria.
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.
There are currently no FAQs about Access 2010: Queries in Depth.
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.