Question 1

____ 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 Null 
A)  Like 
B)  Is Null 
C)  And 
D)  Is Not Null

Question 2

SQL stands for ____.

Accepted Answer

A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language 
A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language

Question 3

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 4

Explain the difference between AND and OR criteria.

Accepted Answer

AND: All criteria must be true in order

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

A)  * 
B)  & 
C)  $?$ 
D)  % 
A)  * 
B)  & 
C)  $?$ 
D)  %

Question 6

Compare the capabilities of queries and filters.

Accepted Answer

* Queries are saved as objects in the da

Question 7

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

Accepted Answer

The answer of To search for a pattern, you can...

Question 8

Which of the following comparison operators means "not equal to"?

Accepted Answer

A) +=+ B) =/= C) <<>> D) <> A) +=+ B) =/= C) <<>> D) <>

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

SQL stands for ____.

A filter can be used to create calculated fields.

Explain the difference between AND and OR criteria.

Compare the capabilities of queries and filters.

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

Which of the following comparison operators means "not equal to"?

Getting Started With Access

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 2: Building and Using Queries

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

SQL stands for ____.

A filter can be used to create calculated fields.

Explain the difference between AND and OR criteria.

Compare the capabilities of queries and filters.

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

Which of the following comparison operators means "not equal to"?

Getting Started With Access

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters