Making All Fields of Tables Accessible

Most queries you create include only the fields you specifically choose. To choose these fields, you either select them from or type them into the drop-down combo list in the Query Design grid's Field row, or you drag the field names from the field lists to the appropriate cells in the Field row. You can, however, quickly include all fields of a table in a query. Access provides the following three methods for including all fields of a table in a query:

• Double-click the field list title bar of the table to select all fields in the field list and then drag the field list to the Query Design grid. Each field appears in a column of the grid.

• Drag the asterisk (*) to a single Query Design grid column. To sort on or apply selection criteria to a field, drag the field to the Query Design grid and clear the Show check box for the field.

• Set the Output All Fields property value in the Query Properties sheet to Yes to add with asterisks all fields of all tables to the grid.