Case-Based Critical Thinking Questions
Case 5-2
Simon has just discovered the power of using text filters to control which records display in his worksheet,and he has begun to use them often to find precisely the records he needs.The following questions are based on a staff directory table that includes First Name,Last Name,Office Number,Department Name,and Phone Number.
-If Simon wants to find all of his colleagues whose last names end in "berg" (such as Goldberg and Steenberg),what should he do?
A) Create a text filter using the Ends With operator to display all records that have dberg as the last characters in the text value.
B) Create a text filter using the Contains operator to display all records that include berg in the text value.
C) Create a text filter using the Ends With operator to display all records that have berg as the last characters in the text value.
D) Create a text filter using the Contains operator to display all records that have berg as the last characters in the text value.

Question

Quizplus · Accepted Answer

To find all of his colleagues whose last names end in "berg," Simon should create a text filter using the Ends With operator to display all records that have "berg" as the last characters in the text value. The Ends With operator will only show records where the last characters of the text value match the specified criteria. Using the Contains operator instead may result in records being displayed where the "berg" is not at the end of the last name. Option A looks for words that end in "dberg," which is not what Simon is looking for. Option D looks for records that have "berg" somewhere in the text value, not just at the end.