Microsoft KB Archive/304356

= How to modify query properties in Microsoft Access =

Article ID: 304356

Article Last Modified on 3/26/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q304356



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

This article applies only to a Microsoft Access database (.accdb and .mdb). For a Microsoft Access 2000 version of this article, see 304357.



For a Microsoft Access 97 version of this article, see 304451.



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 List Properties
To view the field list properties, in Design view of any query, right-click in any cell in the query design grid, and then click Properties on the shortcut menu.

Note The following two properties are not available in Access 2000:
 * Default
 * View Orientation

Note The following two new properties were added in Access 2007 for queries:
 * Filter On Load
 * Order By On Load

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

304462 ACC2002: How to Add Lookup Fields in a Microsoft Access Table

