Which of the Following Is True of Creating Queries with Functions

question 6

Multiple Choice

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.

---

Definitions:

Myringotomy

A surgical procedure to create an opening in the eardrum to drain fluid or relieve pressure.

Otoplasty

A surgical procedure to change the shape, position, or size of the ears.

Stapedectomy

A surgical procedure aimed at improving hearing by removing part or all of the stapes bone in the middle ear and replacing it with a small prosthetic device.

Tympanectomy

A surgical procedure involving the removal of all or part of the eardrum, often to treat infections or other ear problems.