To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.
In microsoft access database changing a caption for a field in a query. You will need to click on the caption button on the design tab, enter new caption after clicking the caption box.