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.
If you have access to the exercise files used throughout this title, you can put them on the desktop as I've done or anywhere that makes sense to you. Exercise files for this title are arranged by chapter. Within each chapter folder is a database that we will be using for exercises in that chapter. I also wanted to point out that I have made use of the custom grouping levels in Access's navigation pane, so the database objects that we will be using for Chapter 1 are in the Chapter 1 custom group. Finally, I wanted to mention the security warning. If you get this security warning, go- ahead and either enable the content or simply close the message bar.
If you don't have access to the exercise files, you could follow along using your own Access database. Now, let's get started!
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.