Exam 17: Access 2013 : Improving Queries

A select query can be used to develop summary calculations,such as the sum of the values in a field.

Filtering refers to reordering records in either ascending or descending order based on the values in the field._________________________

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

-An SQL statement determines how the tables are joined after the ____ keyword

-In the accompanying figure,item 1 refers to a(n)____.

A summary query calculates statistics about ____.

-In Query Design View,primary key fields in a field list are ____.

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

-In the query shown in the accompanying figure,what sort orders have been specified?

The > comparison operator means ____.

In the query design grid,what characters surround text criteria?

In Query Design View,a table's name displays in the field list title bar.

The < comparison operator means ____.

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

____ queries summarize data in which one or more fields are chosen for the row headings,another for the column heading,and yet another for the field summarized within the datasheet itself.

-In the query shown in the accompanying figure,what are the names of the tables involved in the query?

In Query Design View,one-to-many join lines identify linking fields between related tables.