Exam 2: Building and Using Queries

To find numbers greater than or equal to 500, use which comparison operator?

SQL stands for ____.

Filters are used to select a subset of records in a datasheet.

Compare the capabilities of queries and filters.

A query is commonly used as the source of data for a form or report.

In the figure above, item 5 points to the ____.

Filter By ____________________ filters records based on more than one selection criteria by using a special window.

This button helps search for data in a single field or in all fields.

Daniel Arno owns a lawn and landscape business.He has some very particular clients who want their lawns manicured on a specific day of the week.He has other clients who allow him to use his own judgement as to when their lawns need cutting.To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision, and fee.Daniel creates a table called Customers.For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Daniel creates a query using the Name, Day of the Week, and Subdivision fields.He wants to sort the records by day of the week, beginning with Monday and ending with Sunday.He decides to number each day of the week: 1=Monday, 2=Tuesday, and so forth. a. Will his idea work? b. Why or why not? c. Should he plan to sort in ascending or descending order?

A(n)____ is a temporary view of the data whose criteria are always discarded when you close the datasheet.

Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field.

A(n)____ is a saved view of the data whose criteria is not discarded when you close the datasheet.

A query allows the selection of several fields and records from one or more tables, then presents the selected data as a single datasheet.

A(n)____________________ is a database object that creates a datasheet of specified fields and records from one or more tables.

The wildcard character that stands for any single character is the ____.

A join line is also called a ____ line.

In Query Design View, record selectors are thin gray bars above the field names.

A filter can be used to create calculated fields.

____ will find all records where there is any entry in the field, even if the entry is 0.

In the figure above, item 3 points to ____.