Question 1

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

Accepted Answer

Landscape orientation is wider than it is tall, making it ideal for creating wider pages such as for presentations or documents like spreadsheets.

Question 2

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

Accepted Answer

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

Question 3

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?
A) Find
B) Like
C) Search
D) Near

Accepted Answer

The "Like" operator is commonly used in database queries to filter data using wildcard characters, allowing for flexible search patterns.

Question 4

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?
A) =
B) #=#
C) <>
D) >=

Accepted Answer

The comparison operator "<>" means "not equal to," so using this operator will allow Daniel to filter his customer data to only show those who do not live in Oxford.

Question 5

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 more rows of OR criteria to the query design grid increases the number of records selected for the resulting datasheet. The more criteria that are added, the more inclusive the query becomes.

Question 6

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 cancel the most recent action, allowing you to revert to the original state before the find-and-replace effort.

Question 7

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

Accepted Answer

header

Question 8

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

Accepted Answer

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

Quiz 2: Building and Using Queries

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

Match each term with the statement that best describes it.

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?

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

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