condition filter sort Lesson 3: Creating Queries: Review Questions TRUE / FALSE Circle T if the statement is true or F if the statement is false. T F 1. When you sort a field that contains text values in ascending order, data is arranged from A to Z. T F 2. Applying a filter is a temporary way of selecting records in a datasheet. T F 3. To remove a filter from a datasheet, click the Cancel Filter button. T F 4. A common field used to relate tables must have the same field name in the related table. 5. The >= relational operator selects records that are greater than or equal to the value in the T F condition. WRITTEN QUESTIONS Write a brief answer to each of the following questions. What information do you specify when you run the Simple Query Wizard? What steps do you follow to use Filter By Form in a datasheet?
condition filter sort Lesson 3: Creating Queries: Review Questions TRUE / FALSE Circle T if the statement is true or F if the statement is false. T F 1. When you sort a field that contains text values in ascending order, data is arranged from A to Z. T F 2. Applying a filter is a temporary way of selecting records in a datasheet. T F 3. To remove a filter from a datasheet, click the Cancel Filter button. T F 4. A common field used to relate tables must have the same field name in the related table. T F 5. The >= relational operator selects records that are greater than or equal to the value in the condition. WRITTEN QUESTIONS Write a brief answer to each of the following questions. What information do you specify when you run the Simple Query Wizard? What steps do you follow to use Filter By Form in a datasheet?