Case 6-2
Jennifer helped you tremendously as you created your data source.Your challenge now is that your data source is chock-full of records - not all of which you need all the time.It is time to learn about filtering options.
-You want to limit your work today to records that have a second address line.Which of the following filter criteria selects records that have something in the Address Line 2 field?
A)empty
B)blanks
C)null
D)nonblanks

Question

Quizplus · Accepted Answer

The filter criteria "nonblanks" selects records that have any value in the specified field, which in this case would be Address Line 2. "Empty" and "blanks" would not select records with a value in Address Line 2. "Null" would be the most specific criteria, but it is not always reliable as some systems may not use null values consistently.

Case 6-2 Jennifer Helped You Tremendously as You Created Your Data Source.Your