Each query associated with a view has its own property sheet, which contains the following tabs:
SQL (see Query property sheet SQL tab)
Tables (see Query property sheet Tables tab)
Columns (see Query property sheet Columns tab)
Where (see Query property sheet Where tab)
Group By (see Query property sheet Group By tab)
Having (see Query property sheet Having tab)
Order By (see Query property sheet Order By tab)
You can manipulate each of these clauses using the lists in these tabs, and any changes you make will propagate to the other tabs and the SQL Query tab of the parent view (see Editing query code in the SQL Query tab).