Case 19-3 Linda Has Recently Started Her Job as a Nursing

Multiple Choice

Case 19-3 Linda has recently started her job as a nursing supervisor at Hankons Cancer Treatment Centre. As part of the job, she has to look into the database of all the currently admitted patients and their ongoing treatment status.
​ Linda uses Microsoft Access 2016 to maintain the records of each patient. She wants to list the patients' names whose name start with "e" and end with "y" and contain four letters. Which of the following wildcard characters should Linda use for this search?

A) e[e-y][e-y]y
B) e[a-z][a-z]y
C) e [_ _] y
D) e [**]y