Exam 6: Modifying the Database Structure

When you open a query in Datasheet View, you run it.

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

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

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

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

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

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

Access helps you with criteria syntax in the query design grid.

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

The < comparison operator means ____.

A query can display fields from one or more tables in a relational database.

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.

Discuss the use of the * wildcard character in query criteria.

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

Which function should you use to calculate the monthly payment on a loan?

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

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

The < comparison operator means ____.

Queries evaluate sort orders from left to right .

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