Question

The statement Like "A?9 can be used as a query criterion to match several field values. List any one example of a field value that would match this criterion. 3. What specific type of query would use the following criterion? Like [Enter name:] & 4. What aggregate function would be used to output the number of nonnull field values in a crosstab query? 5. 6. The value Is Null would be used as a criterion in which specific type of query? The statement 999\-000\-0000 is an example of a(n), general attributes. 7. in a table field's The statement Invoice amounts must be greater than 5 is an example of a(n) 8. in a table field's general attributes. 9. A query can be designed using an SQL select statement. The SQL statement may include the following keywords - SELECT, FROM, INNER JOIN, WHERE and ORDER BY. Which of the five keywords is used to identify the criteria used to select table records? Which of the five SQL select statement keywords must be added when the data is being selected and combined from two or more tables? 10.

Answer all questions

Answer 1

3. One such value that would match the criterion is A39.

5. The aggregate function is count(*).

6. IS NULL is used to check for values which are null.

7. This represents a phone number in a table.

NOTE: As per Chegg policy I am allowed to answer specific number of questions (including sub-parts) on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.