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.
You already know how to plan and run a basic query. This lesson will show you how to run a query that includes a Totals function to group and count the records in the results. It will also deal with ways to further sort and filter via your query design to further refine your results.