If a parameter query prompts and searches for words that contain the entered characters anywhere in the field, then which of the criteria below is the correct one?
A) LIKE [Enter the first character of the last name:] & "*"
B) LIKE "*" & [Enter any character(s) to search by:] & "*"
C) [Enter start date:]
D) None of the above

Question

Quizplus · Accepted Answer

The criteria "LIKE "*" & [Enter any character(s) to search by:] & "*"" is the correct one because it uses wildcard characters (*) to search for any characters before and after the entered characters, allowing for a search of words that contain the entered characters anywhere in the field. The other criteria are irrelevant to this type of parameter query.

If a Parameter Query Prompts and Searches for Words That