You can rename a field in a query to describe the field's data more accurately. This is particularly useful when you define a new calculated field or calculate a sum, count, or another type of total on an existing field. In such cases, unless you enter a name, Microsoft Access assigns names such as Expr1 or SumOfOrder Amount. The new field name must follow object-naming rules.
Display new field names by changing them in the design grid
Display new field names by changing the Caption property