Change a field's caption in a query

1. Open a query in Design view.
   
   
2. In the design grid, click anywhere in the column of the field whose caption you want to change, and then click Properties on the toolbar.
   
   
3. In the Caption property box, type the new caption for the field.