Question 1

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

Accepted Answer

A) True 
 B)False  False

Question 2

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

A) True 
 B)False  False

Question 3

Compare the capabilities of queries and filters.

Accepted Answer

1.Queries are saved as objects in the database.Filters are not
2.Both can be used to select a subset of records in a database
3.Only queries are used to select a subset of fields in a database
4.The resulting datasheet from both filters and queries can be used to enter and edit data
5.The resulting datasheet from both filters and queries can be used to sort, filter, and find data
6.Queries but not filters are commonly used as the source of data for a form or report
7.Queries but not filters can be used to create calculations across records
8.Queries but not filters can be used to create calculated fields.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Explain the difference between AND and OR criteria.

Accepted Answer

The answer of Explain the difference between AND and OR...

Question 6

When you double-click a field in a field list in Query Design View, it is

Accepted Answer

A)   Deleted from the query
B)   Added to the next available position in the query design grid
C)   Used as the first sort order
D)   Set as the primary key field

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)   Records
B)   Link line
C)   Datasheet
D)   Tables

Question 10

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

Accepted Answer

A) True 
 B)False

Question 11

Is ____________________ criteria will find all records where no entry has been made in the field.

Accepted Answer

The answer of Is ____________________ criteria will find all records...

Question 12

Criteria ____ is the term for rules by which criteria must be entered in a query.

Accepted Answer

A)   Syntax
B)   Formatting
C)   Sorting
D)   Filter by Form

Question 13

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In the figure above, which button would you use to filter for an exact match?

Accepted Answer

A)   2
B)   3
C)   4
D)   5

Question 16

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 17

In the figure above, which button opens the Find and Replace dialog box?

Accepted Answer

A)   3
B)   4
C)   5
D)   6

Question 18

A join line is also called a ____ line.

Accepted Answer

A)   Query
B)   Link
C)   Connection
D)   Objectivity

Question 19

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?

Accepted Answer

A)   0
B)   Is Not Null
C)   *=*
D)   * *

Question 20

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...

Exam 2: Building and Using Queries

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Compare the capabilities of queries and filters.

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

Explain the difference between AND and OR criteria.

When you double-click a field in a field list in Query Design View, it is

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

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

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

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

Is ____________________ criteria will find all records where no entry has been made in the field.

Criteria ____ is the term for rules by which criteria must be entered in a query.

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.

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

In the figure above, which button would you use to filter for an exact match?

In the figure above, which button opens the Find and Replace dialog box?

A join line is also called a ____ line.

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?