What steps are involved in applying a filter that shows records where CourseDescription contains 'Foundation'?

Using the Custom Filter dialog is the correct approach for applying a filter that shows records where the CourseDescription contains the word 'Foundation.' This dialog allows users to create specific criteria for filtering data based on various conditions.

In this case, the Custom Filter dialog is ideal because it provides the ability to specify custom conditions, such as containing a specific substring. When you want to filter data based on whether a certain term appears anywhere within a text string (in this case, 'Foundation' within CourseDescription), the Custom Filter dialog allows you to set this up efficiently.

The other options do not precisely fit the requirement for filtering by a substring within the CourseDescription field. For example, selecting criteria that indicate 'Starts With' would not adequately filter records where 'Foundation' appears later in the description. Similarly, setting criteria for CourseCode or checking the Show checkbox are unrelated to filtering based on a text substring within the CourseDescription. Hence, utilizing the Custom Filter dialog is the most effective method to achieve the desired filtering result.