Case-Based Critical Thinking Questions

question 40

Multiple Choice

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.

---

Definitions:

1980s

The decade spanning from January 1, 1980, to December 31, 1989, characterized by significant political, technological, and cultural changes worldwide.

Life Expectancy

The average period that an individual is expected to live, based on statistical averages of age, nationality, and other factors.

Census Data

Statistical information collected through the systematic enumeration of a population, including demographics, employment, and housing.

60s Scoop

Refers to the practice, primarily in Canada during the 1960s, of removing Indigenous children from their families and communities for placement in foster homes or adoption by primarily white families.