Question 1

Deleting a field from a query also deletes it from the underlying table.

Accepted Answer

A) True 
 B)False

Question 2

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

Accepted Answer

The answer of To search for a pattern, you can...

Question 3

Match between columns
                        Premises: Criterion that finds all records where no entry has been made in the field

Accepted Answer

The Answer of query and filter and Is Null and is...

Question 4

Compare the capabilities of queries and filters.

Accepted Answer

The answer of Compare the capabilities of queries and filters....

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A join line is also called a(n) ____ line.

Accepted Answer

A)  query 
B)  link 
C)  connection 
D)  objectivity

Question 7

Case 2-1 
Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. 
-Daniel uses a one-character code to indicate which day of the week certain customers of his have their lawns cut. Which of the following wildcard characters could he use to search for a single character (e.g., F for Friday)?

Accepted Answer

A)  * 
B)  & 
C)  $?$ 
D)  %

Question 8

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Accepted Answer

A)  Comparative 
B)  Selection 
C)  Comparison 
D)  Advanced

Question 9

A(n) ____ is a saved object within the datasheet.

Accepted Answer

A)  query 
B)  filter 
C)  find 
D)  union

Question 10

To make a page wider than it is tall, use landscape orientation.

Accepted Answer

A) True 
 B)False

Exam 2: Building and Using Queries

Deleting a field from a query also deletes it from the underlying table.

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

Match each term with the statement that best describes it.

Compare the capabilities of queries and filters.

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

A join line is also called a(n) ____ line.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

A(n) ____ is a saved object within the datasheet.

To make a page wider than it is tall, use landscape orientation.