Specifies the table to create the query, and specifies which fields you wish to include in the query.
Tables
Specifies the table for which the query is to be created.
Available fields
Lists the names of the data base fields in the selected table or query. Click to select a field or hold down the Shift or the CommandCtrl key while you click to select more than one field.
>
Click to move the selected field(s) to the box that the arrow is pointing to.
>>
Click to move all fields to the box that the arrow is pointing to.
<
Click to move the selected field(s) to the box that the arrow is pointing to.
<<
Click to move all fields to the box that the arrow is pointing to.
^
Click to move the selected field up one entry in the list.
v
Click to move the selected field down one entry in the list.
Fields in the Query
Displays all fields that will be included in the new query.