Special Edition Using Access 97, Second Edition

Making All Fields of Tables Accessible

Most queries that 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, include all fields of a table in a query. Access provides three methods, which are covered in the following sections.

Using the Field List Title Bar to Add All Fields of a Table

One way to include all fields of a table in a query is to use the field list title bar or asterisk. To use this method in your query to include all fields, together with their field name headers, follow these steps: ...