Briefly describe Filter by Selection and Filter by Form.  Imagine that you are searching for songs in a database.  Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.

What will be an ideal response?

- When you use Filter By Selection, you select a field value (such as Oak Office Desk), or part of a field value (such as the just letter D) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab. A menu opens with a list of options for filtering the field.

Situation Examples (Answers will vary):
Filter by the name of an artist
Filter by the name of a song
Filter for songs recorded before a certain year
Filter for songs recorded in a certain year

- You can use Filter By Form when you need to display records that contain one or more values based on the values stored in one or more fields. To use Filter By Form, click the Advanced button in the Sort & Filter group on the Home tab.

Situation Examples (Answers will vary):
Show songs that were released on CD in the year 2010
Show songs by Elvis released by RCA
Show songs that start with the word "White" recorded by "Bing Crosby"