Define the three types of data filters and give an example of when each may be used
What will be an ideal response?
• Filter by form: you may want to filter the records that have a "Santa Fe" value in the "City" field. The Filter by Form type could be used, which allows you to filter data in a form or datasheet.
• Filter by selection: this method works well if you see a value you want to use as a filter.
• Advanced filter: Because the Filter by Form or Filter by Selection filters may not give enough options, as they are fairly basic, you might want to apply a filter that is an advanced filter in which you write the filter criterion yourself. For example, you may want to find products that contain dates occurring during the past seven days. After you apply an advanced filter, you can further limit the results to those that have a price of over $100 . Using the advanced filters does require writing expressions.
You might also like to view...
Which binary operator returns 0 if both numbers it compares are the same and returns 1 if the numbers it compares are different?
a. XOR b. OR c. AND d. ROT13
ostream member function _______ is generally used to write data to a randomly ac- cessed file.
Fill in the blank(s) with the appropriate word(s).