Exam 17: Access 2013 : Improving Queries

-In the accompanying figure,the criteria in the first row of the query would be considered AND criteria.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Queries evaluate sort orders from left to right._________________________

You can specify more than one sort field in Query Design View.

A(n)____ character is used in criteria to represent any combination of characters.

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.

The wildcard character that represents one character in query criteria is the ____.

You can view the SQL code for any query by switching to Code View._________________________

The ____ function returns the number of characters in a field.

-____ criteria are two or more criteria on the same Criteria row of the query design grid.

-In the accompanying figure,item 3 points to ____.

The ____ function returns a number of characters from the first part of a field.

Which aggregate function is used to find the average of values in a field?

Deleting a field from the query design grid deletes it from the database table that contains that field.

When the comparison operator Null is used as criteria in the query design grid,the query finds records in which ____.

A select query is the most common type of query.

When you are saving a query,you are saving a set of instructions written in Standard Query Language._________________________

SQL statements start with the FROM keyword._________________________

Which aggregate function would NOT work well on a Short Text field?