Marcus, a professor, uses Microsoft Access 2016 to retrieve and refine the records in a database that stores students' information. He wants to view the list of students whose percentage ends with .99. Which of the following operators should Marcus use to retrieve the list?
A)="??.99"
B)=".99"
C)Like "*.99"
D)Like "#.99"

Question

Marcus, a professor, uses Microsoft Access 2016 to retrieve and refine the records in a database that stores students' information. He wants to view the list of students whose percentage ends with .99. Which of the following operators should Marcus use to retrieve the list? ​
A)="??.99"
B)=".99"
C)Like "*.99"
D)Like "#.99"

Quizplus · Accepted Answer

The correct operator to use in this scenario is Like "*.99". This operator allows for any characters to precede ".99", effectively matching any percentage value that ends with .99.

Marcus, a Professor, Uses Microsoft Access 2016 to Retrieve and Refine