Which of the following is true of creating queries with functions in Microsoft Access 2016?
A)Functions need to be applied to all the fields in a table and not to specific fields.
B)After a query is run, the query datasheet uses a default column name that cannot be changed.
C)Functions cannot operate the records that meet a query's selection criteria.
D)For each calculation to be executed on a field, the field should be added to the design grid.

Question

Which of the following is true of creating queries with functions in Microsoft Access 2016? ​
A)Functions need to be applied to all the fields in a table and not to specific fields.
B)After a query is run, the query datasheet uses a default column name that cannot be changed.
C)Functions cannot operate the records that meet a query's selection criteria.
D)For each calculation to be executed on a field, the field should be added to the design grid.

Quizplus · Accepted Answer

For calculations to be performed on a field in a query in Microsoft Access 2016, that field must be included in the design grid. This allows the user to specify the calculation to be performed on the field.

Which of the Following Is True of Creating Queries with Functions