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

Question

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

Quizplus · Accepted Answer

CB) The pattern "e[a-z][a-z]y" correctly specifies a name that starts with "e", ends with "y", and has two letters in between that can be any letter from a to z, making up a four-letter word.C) The pattern "e [_ _] y" uses underscores as placeholders for single characters, indicating that there should be exactly two characters between "e" and "y", which matches the requirement for a four-letter word starting with "e" and ending with "y".

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