Cali Has Just Discovered the Power of Using Text Filters

question 29

Multiple Choice

Cali 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 camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number.
-To find anyone whose Camp is either Day Camp,or Overnight Camp,or Nature Camp,what should he do?

• A)Create a text filter using the Contains operator to display all records that have Nature anywhere in the text value.
• B)Create a text filter using the Ends With operator to display all records that have Day as the last characters in the text value.
• C)Create a text filter using the Begins With operator to display all records that have Overnight as the first characters in the text value.
• D)Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.

---

Definitions:

Sheltered Workshop

A workplace that provides employment and training for people with disabilities under a protected and supervised environment.

Recycling Center

A facility where materials are collected, sorted, processed, and turned into new products in order to reduce waste and conserve resources.

Employment Center

A facility or service that provides resources, tools, and support for job seekers and employers.

Homeless People

Individuals who lack stable, safe, and adequate housing, which includes those who sleep on the streets, in shelters, or in temporary accommodations.