The Query Join menu indicates the relationship of each criteria to the statements already part of your existing query. There are four options for creating these relationships: and, or, and not, and or not. Query Join will have no effect on the first line of your query. Join uses standard logical definitions, therefore and and and not will always narrow down your results by searching for records where ALL of the specified conditions apply, while or and or not will always widen your field of results by searching for records with EITHER or ANY of the specified conditions.
Sub-Queries allow you to put multiple conditions on a single set of search results. For more information about sub-queries, see the section on Using Sub-Queries.
Table has eight options determining the specific data by which you wish to filter your results. When you select a table the Field menu is populated with all of the individual fields that are stored in the selected table.
Field describes the exact piece of data by which you wish to filter your results. All fields in the database can be classified into one of the five basic categories: Date, Numerical, Text, Logical (True/False), and List-based.