how_to_create_a_query_in_access_7

Screenshot of the query in Design view with criteria added. MS Access 2013.

Design view allows you to add criteria with which to filter the results. Here, we’ve added criteria to filter the results to only those with a price over a certain amount (80000).