Question 1

Match between columns
                        Premises: Used to search for a pattern
Creates a temporary subset of records
Criterion that finds all records where no entry has been made in the field
Creates a datasheet of selected fields and records from one or more tables
Limiting conditions used to narrow the number of records on a datasheet
The lower pane in Query Design View
Putting records in ascending or descending order based on a field's values
Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

Accepted Answer

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

Question 2

If, for example, a find-and-replace effort does not work correctly, click the Undo button to cancel the changes.

Accepted Answer

Clicking the Undo button will undo the changes made during the find-and-replace effort that did not work correctly.

Question 3

By default, the printout of a datasheet contains the object name and current date in the footer .

Accepted Answer

header

Question 4

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

As you add rows of OR criteria to the query design grid, you increase the number of records selected for the resulting datasheet, as any record that matches at least one of the OR criteria will be included.

Question 5

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

Accepted Answer

field

Question 6

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many clients. 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 wildcard character that can be used to search for a single character is "?", so option C - "(?)" is the best choice. The other wildcard characters have different functions - "*" represents a string of text or characters, "%" represents any number of characters, and "&" is not a wildcard character.

Question 7

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many clients. 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 allows the use of wildcard characters, such as * and ?, in database searches, which is what Daniel wants to do to filter the data about his customers in various ways.

Question 8

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

Accepted Answer

Landscape orientation refers to the page being wider than it is tall, while portrait orientation refers to the page being taller than it is wide.

Quiz 2: Building and Using Queries

Match each term with the statement that best describes it.

If, for example, a find-and-replace effort does not work correctly, click the Undo button to cancel the changes.

By default, the printout of a datasheet contains the object name and current date in the footer .

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

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

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many clients. 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?

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