Queries allow you to search for and compile data from one or more tables in Access. They are one of the best ways of analyzing the data you have in your database. Depending on what you’re trying to find out, they can range from very simple to very complex. In this video, we’re going to focus on creating a simple query that just uses one table.
When creating a query, you’ll usually include search criteria, which the query uses to filter the results. Even if you have a huge amount of data in your database, you can use search criteria to pinpoint only the data that you need.
If you are interested in learning more about this topic, please visit our site at http://www.gcflearnfree.org/access2010 to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you’ve learned.