You can format a query field.
To modify the appearance of a query field, click anywhere within the query field's column, and then click the Properties button on the toolbar. You can then specify the format, caption, input mask, and other features of the query field.
You can change the order of fields in a query.
In the design grid, point at the column selector for the column you want to move. (The column selector is the thin gray box at the top of a column.) When the pointer changes to a small black arrow, click to select the column. When the black arrow changes back, use the mouse pointer to drag the selected column to a new position.
You can remove a table from the Query design grid.
To remove a table, right-click its field list in the top portion of the Query Design View window, and then click Remove Table. |