Question 1

Match between columns
                        Premises: Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

Accepted Answer

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

Question 2

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 3

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 wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?
A) Find
B) Like
C) Search
D) Near

Accepted Answer

The LIKE operator is used with wildcard characters to search for patterns within data. Therefore, it is the most apt operator for Daniel to use in his searches.

Question 4

Match between columns
                        Premises: Creates a temporary subset of records

Accepted Answer

The Answer of filter and query and sorting and criteria is...

Question 5

Match between columns
                        Premises: Used to search for a pattern

Accepted Answer

The Answer of query and wildcard and sorting and Is is...

Question 6

Match between columns
                        Premises: Putting records in ascending or descending order based on a field's values

Accepted Answer

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

Question 7

Match between columns
                        Premises: Limiting conditions used to narrow the number of records on a datasheet

Accepted Answer

The Answer of sorting and query grid and wildcard and is...

Question 8

Match between columns
                        Premises: The lower pane in Query Design View

Accepted Answer

The Answer of datasheet and Is Null and sorting and is...

Question 9

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)?
A) *
B) &
C) $?$
D) %

Accepted Answer

The \? notation indicates a single wildcard character. The * and % are used for multiple characters, and & is not a valid wildcard character.

Question 10

Match between columns
                        Premises: Creates a datasheet of selected fields and records from one or more tables

Accepted Answer

The Answer of datasheet and Is Null and criteria and is...

Quiz 2: Building and Using Queries

Match each term with the statement that best describes it.

Match each term with the statement that best describes it.

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 wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

Match each term with the statement that best describes it.

Match each term with the statement that best describes it.

Match each term with the statement that best describes it.

Match each term with the statement that best describes it.

Match each term with the statement that best describes it.

Match each term with the statement that best describes it.