Using Queries to Make Data Meaningful - Part 2

In Access queries let you retrieve information from one or more tables on a set of defined search conditions. Learn how to use queries in Access here.

Sorting and filtering query results

Once you have the results looking how you want them, you can sort and filter them to further narrow your results. This can be done using the methods of sorting and filtering covered in earlier lessons, or by applying a sort and filter in the query design itself.

To sort via the query design:

To filter via the query design: