27. Queries based on more than one table, must have a ____ field.a. commonb. similarc. textd. calculatedANSWER:a Show 28. A field with the Short Text data type sorted in descending order will display the data in which order?c 29. Data may be sorted in a table datasheet, a form, and a ____.b 30. When the sort field data for each record in a database is different, the sort field is ____.b 31. The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.a. tableb. chronologicalc. primaryd. adjacentANSWER:c 32. The AutoFilter sort method works on a(n)____ field(s).d 33. In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when inDesign view.a 34. A criterion, or rule, that determines which records are selected when a query is run is called a(n) ____.b 35. The comparison operator, < >, is used to insert a condition that means ____.a. greater thanb. And
A
What should you use to write criterion into a query?Open your query in Design view. In the query design grid, click the Criteria row of the field where you want to add the criterion. Add the criteria and press ENTER. You can use several types of criteria like text, dates (read about applying criteria to text and using dates as criteria) and functions.
How are a table datasheet and a query datasheet similar?A table datasheet and a query datasheet look the same, appearing in Datasheet view, and can be used to update data in a database. A table datasheet shows the permanent data in a table, whereas a query datasheet is temporary and its contents are based on the criteria you establish in the design grid.
Is a set of records that answers the question resulting from a query?The result of a query is also referred to as a recordset because the query produces a set of records that answers your question.
What should you use to write criterion into a query quizlet?You can use the Like comparison operator and wildcards in a parameter when writing the query criteria. Remember the Like comparison operator can help you find records containing data that is similar to, or like, the criterion value.
|