Microsoft KB Archive/304357

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

Article ID: 304357

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q304357



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

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

For a Microsoft Access 2002 version of this article, see 304356.



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 a field in the query design grid, and then click Properties on the shortcut menu.

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

304439 ACC2000: Explanation of Data Types and Field Properties in a Microsoft Access Database

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

304463 ACC2000: How to Add Lookup Fields in a Microsoft Access Table

