The Query Design

The query design is a visual representation of the families, fields, and criteria that the query is configured to return. When designing a query, you can customize it to return specific records using specific formatting and criteria. As you design a query, SQL code is generated to store the code that is represented by the visual design.

The query design appears you click the Design View link on the Query Tasks menu while you are viewing query results or SQL code.

When you design a query, you can use the following areas to add sources, fields, and query criteria:

The following image shows an example of a query design.