Microsoft KB Archive/304451

= ACC97: How to Modify Query Properties in Microsoft Access =

Article ID: 304451

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q304451



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SUMMARY
This article shows you how to modify query properties in Microsoft Access. This information is useful if you want to perform such tasks as:
 * Change the display of fields.
 * Create top value queries.
 * Add an alias for a table.
 * Change field captions and formatting.



Query Properties
To view all the query properties, in Design view of any query, right-click in an empty space in the query design window, and then click Properties on the shortcut menu.

The following table lists all the query properties and explains what each one is used for.

Field Properties
To see the field properties, in Design view of any query, right-click in the field in the query design grid, and then click Properties on the shortcut menu.

The following table lists all the field properties and explains what each one is used for.

Field List Properties
To see the field list properties, in Design view of any query, right-click on a field in the field list, and then click Properties on the shortcut menu.

The following table lists all the field list properties and explains what each one is used for.

For additional information about general field properties, click the article number below to view the article in the Microsoft Knowledge Base:

304445 ACC97: Explanation of Data Types and Field Properties in a Microsoft Access Database

