The field name should appear as the renamed field in Query for most fields.  If the original field name appears, exit and sign out (BB16633) of the program, then open Query again.  The renamed fields should appear in the list of available fields.
Changing the field name in the Field Characteristics section does not change the table name.

NOTE: This option is not available for all fields