Question 1

The record selector button is to the right of a record in a datasheet.

Accepted Answer

left

Question 2

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

Accepted Answer

increase

Question 3

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

Accepted Answer

The answer of Any edits you make in a query...

Question 4

Match between columns
                        Premises: Criterion that finds all records where no entry has been made in the field
Creates a temporary subset of records
Used to search for a pattern
Rules that determine how criteria is entered
Creates a datasheet of selected fields and records from one or more tables
The lower pane in Query Design View
Limiting conditions used to narrow the number of records on a datasheet
Putting records in ascending or descending order based on a field's values

Accepted Answer

The Answer of Wildcard and Query and Filter and Query is...

Question 5

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

Accepted Answer

The answer of In Query Design View, record selectors are...

Question 6

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?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 7

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 wants to build a query that will show each customer name, day of the week (if specific), and subdivision.What criterion should he use to quickly find his customers whose day of the week varies?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 8

SQL is the acronym for " simple query language ".

Accepted Answer

SQL stands for "Structured Query Language".

Quiz 2: Building and Using Queries

The record selector button is to the right of a record in a datasheet.

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

Match each term with the statement that best describes it.

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

SQL is the acronym for " simple query language ".