Question 1

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?

Accepted Answer

A)   Find
B)   Like
C)   Search
D)   NearE) All of the above
F) B) and C)

Question 2

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

A) True 
 B)False

Question 3

Compare the capabilities of queries and filters.

Accepted Answer

* Queries are saved as objects in the da...

Question 4

Discuss adding or deleting a table in a query.

Accepted Answer

You might want to add a table's field li...

Question 5

Access saves ____ automatically as you move from record to record.

Accepted Answer

A)   data
B)   queries
C)   tables
D)   all of the aboveE) All of the above
F) B) and D)

Question 6

Match between columns
                        Premises: Creates a datasheet of selected fields and records from one or more tables
The lower pane in Query Design View
Criterion that finds all records where no entry has been made in the field
Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines
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

Accepted Answer

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

Question 7

Criteria ____ is the term for rules by which criteria must be entered in a query.

Accepted Answer

A)   Syntax
B)   Formatting
C)   Sorting
D)   Filter by FormE) All of the above
F) C) and D)

Question 8

The wildcard character that stands for any single character is the ____.

Accepted Answer

A)   ampersand (&) 
B)   question mark (?) 
C)   exclamation mark (!) 
D)   caret (^) E) B) and D)
F) C) and D)

Question 9

To find numbers greater than or equal to 500, use which comparison operator?

Accepted Answer

A)   #
B)   
C)   >>
D)   >=E) A) and B)
F) B) and C)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following comparison operators means "greater than"?

Accepted Answer

A)   >
B)   >=
C)   
D)   <=E) A) and C)
F) A) and B)

Question 13

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 14

To filter for comparative data, use the Filter By Selection feature.

Accepted Answer

A) True 
 B)False

Question 15

____________________ are limiting conditions you set in the query design grid.

Accepted Answer

The answer of ____________________ are limiting conditions you set in...

Question 16

____ will find all records where there is any entry in the field, even if the entry is 0.

Accepted Answer

A)   Like
B)   Is Null
C)   And
D)   Is Not NullE) B) and C)
F) C) and D)

Question 17

Enter OR criteria on different Criteria rows in the query design grid.

Accepted Answer

A) True 
 B)False

Question 18

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Accepted Answer

The answer of Filter By ____________________ is a fast and...

Question 19

SQL stands for ____.

Accepted Answer

A)   Structured Query Lingo
B)   Standard Query Lingo
C)   Standard Query Language
D)   Structured Query LanguageE) All of the above
F) A) and C)

Question 20

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

Accepted Answer

A) True 
 B)False

Exam 2: Getting Started With Access 2013

A query can be used to create calculated fields.

Correct Answer
verified

Which of the following comparison operators means "greater than"?

Correct Answer
verified

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Correct Answer
verified

The wildcard character that stands for any single character is the ____.

Correct Answer
verified

Enter OR criteria on different Criteria rows in the query design grid.

Correct Answer
verified

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?

Correct Answer
verified

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

Correct Answer
verified

____________________ are limiting conditions you set in the query design grid.

Correct Answer
verified

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

Correct Answer
verified

A filter can be used to create calculated fields.

Correct Answer
verified

Criteria ____ is the term for rules by which criteria must be entered in a query.

Correct Answer
verified

____ will find all records where there is any entry in the field, even if the entry is 0.

Correct Answer
verified

Compare the capabilities of queries and filters.

Correct Answer
verified
* Queries are saved as objects in the da...
View Answer

To filter for comparative data, use the Filter By Selection feature.

Correct Answer
verified

To find numbers greater than or equal to 500, use which comparison operator?

Correct Answer
verified

Access saves ____ automatically as you move from record to record.

Correct Answer
verified

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

Correct Answer
verified

Discuss adding or deleting a table in a query.

Correct Answer
verified
You might want to add a table's field li...
View Answer

SQL stands for ____.

Correct Answer
verified

Match each term with the statement that best describes it.

Exam 2: Getting Started With Access 2013

A query can be used to create calculated fields.

Correct AnswerverifiedShow Answer

Which of the following comparison operators means "greater than"?

Correct AnswerverifiedShow Answer

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Correct AnswerverifiedShow Answer

The wildcard character that stands for any single character is the ____.

Correct AnswerverifiedShow Answer

Enter OR criteria on different Criteria rows in the query design grid.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

Correct AnswerverifiedShow Answer

____________________ are limiting conditions you set in the query design grid.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A filter can be used to create calculated fields.

Correct AnswerverifiedShow Answer

Criteria ____ is the term for rules by which criteria must be entered in a query.

Correct AnswerverifiedShow Answer

____ will find all records where there is any entry in the field, even if the entry is 0.

Correct AnswerverifiedShow Answer

Compare the capabilities of queries and filters.

Correct Answerverified* Queries are saved as objects in the da...View AnswerShow Answer

To filter for comparative data, use the Filter By Selection feature.

Correct AnswerverifiedShow Answer

To find numbers greater than or equal to 500, use which comparison operator?

Correct AnswerverifiedShow Answer

Access saves ____ automatically as you move from record to record.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Discuss adding or deleting a table in a query.

Correct AnswerverifiedYou might want to add a table's field li...View AnswerShow Answer

SQL stands for ____.

Correct AnswerverifiedShow Answer

Match each term with the statement that best describes it.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
* Queries are saved as objects in the da...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
You might want to add a table's field li...
View Answer

Correct Answer
verified