Question 1

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

Accepted Answer

header

Question 2

Critical Thinking Questions 
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

The wildcard character ? is used to search for a single character.

Question 3

Match between columns
                        Premises: 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
The lower pane in Query Design View
Creates a temporary subset of records
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
Used to search for a pattern
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 wildcard and criteria and filter is...

Question 4

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 revert the changes made by the find-and-replace effort.

Question 5

Critical Thinking Questions 
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?

Accepted Answer

The LIKE operator is used to find records that match a specified pattern. Wildcard characters can be used in the pattern to match any character or any number of characters. For example, the pattern "D%" would match all records that start with the letter "D".

Question 6

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

Accepted Answer

Landscape orientation is designed to make a page wider than it is tall, whereas portrait orientation is designed to make a page taller than it is wide.

Question 7

Critical Thinking Questions 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 lives in Oxford and he would like to find all customers who do not live in Oxford. Which comparison operator should he use?

Accepted Answer

The comparison operator "<>" is used to denote "not equal to" in many programming and database query languages, which is suitable for finding customers who do not live in Oxford.

Question 8

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

Adding rows of OR criteria in the query design grid increases the number of records selected for the resulting datasheet.

Quiz 2: Building and Using Queries

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

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

Critical Thinking Questions 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?

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

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