Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
Before we part, I'd like to share some additional resources that you might find useful in developing your databases. First, I would encourage you to spend some time digging into the Expression Builder. There are over 150 built-in functions to choose from and with Access's context-sensitive help system, it makes it really easy to learn more about each one. Simply select the function that you're interested in, press the Help button, and you'll be taken directly to the reference sheet for that function. Another helpful resource can be found in online discussion forums. I highly recommend the forums at UtterAccess.com.
Here you could join a local Access user group, post questions about specific Access objects or procedures, and even download sample projects and code snippets. A second highly active community can be found at dbforums.com/microsoft-access. Finally, Microsoft's own Access blog regularly features tips and tricks that you can apply to your own database. I want to thank you for joining me as we took a closer look at using queries in Access 2010. Have a great day!
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.