If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one? A) =[Enter start date:] and =[Enter start date:] D) None of the above

Question

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?
A) >=[Enter start date:] and <=[Enter end date:]
B) LIKE [Enter the first character of the last name:] & "*"
C) >=[Enter start date:]
D) None of the above

Quizplus · Accepted Answer

The parameter query needs to prompt for a character and search for any name that begins with that character. The LIKE operator with the wildcard character (*) is used to achieve this. So, the correct criteria would be LIKE [Enter the first character of the last name:] & "*".

If a Parameter Query Prompts and Searches for Any Name