Microsoft Query

This is a separate application designed specifically to create database queries.
SELECT Database

Query Wizard

You can use the query wizard to design the exact query.
allows you to select the tables
columns
add any filters
as well as adding any sorting
how to join the tables

The most useful feature is the database filter
This limits the records to your exact criteria

You can create up to three criteria for any of the selected columns.
or / and if you have multiple criteria

Tables - default to the order they are defined in the database
You can specify up to 3 different sorts.