Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students with the LastName field value beginning with the letter "a" and ending with the letter "n," Emily should enter _____ in the Criteria row in the LastName column in the design grid.
A)In (a,n)
B)Like (a,n)
C)Like "a*n"
D)In "a*n"

Question

Quizplus · Accepted Answer

The correct syntax to use in Microsoft Access to find records where the LastName field starts with "a" and ends with "n" is to use the Like operator followed by the pattern "a*n". The asterisk (*) is a wildcard character that matches any number of characters, so "a*n" matches any string that starts with "a" and ends with "n".

Case 18-1 Emily, a Professor, Uses Microsoft Access 2016 to Manage