Though field names can be changed or assigned in an aggregate query,the field name in the ________ must stay the same so that Access knows what field to perform calculations on.
A) form design wizard
B) total row grid
C) query design wizard
D) query design grid

Question

Quizplus · Accepted Answer

The query design grid is where users specify the fields, criteria, and sorting for their queries in Access. Changing field names in the query does not affect the underlying field names in the tables; hence, the original field names must remain consistent in the query design grid for Access to correctly perform calculations.

Though Field Names Can Be Changed or Assigned in an Aggregate