Question 1

Filters are used to select a subset of records in a datasheet.

Accepted Answer

A) True 
 B)False  True

Question 2

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

A) True 
 B)False  False

Question 3

The ____ button provides a list of values in the selected field that can be used to customize a filter.

Accepted Answer

A)  Values 
B)  Selection 
C)  Filter 
D)  Advanced 
A)  Values 
B)  Selection 
C)  Filter 
D)  Advanced C

Question 4

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Accepted Answer

A)  Comparative 
B)  Selection 
C)  Comparison 
D)  Advanced 
A)  Comparative 
B)  Selection 
C)  Comparison 
D)  Advanced

Question 5

Discuss adding or deleting a table in a query.

Accepted Answer

You might want to add a table's field li

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

To move a field in the query design grid, click its ____, and then drag it left or right.

Accepted Answer

A)  field selector 
B)  field key 
C)  field string 
D)  field tag 
A)  field selector 
B)  field key 
C)  field string 
D)  field tag

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

Question 9

In Access, the Save As command allows you to save either the entire database or the current object with a new name.

Accepted Answer

A) True 
 B)False

Question 10

You can enter, edit, and navigate data in a query datasheet just like a(n) report datasheet. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Quotation marks are automatically added to criteria for fields with a Date/Time data type. ____________________

Accepted Answer

A) True 
 B)False

Question 12

A(n) ____ is a saved object within the datasheet.

Accepted Answer

A)  query 
B)  filter 
C)  find 
D)  union 
A)  query 
B)  filter 
C)  find 
D)  union

Question 13

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

A)  = 
B)  #=# 
C)  ​ 
D)  ​ 
A)  = 
B)  #=# 
C)  ​ 
D)  ​

Question 14

Query criteria are not case sensitive.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The wildcard character that stands for any group of characters is the ____.

Accepted Answer

A)  period (.) 
B)  semicolon (;) 
C)  asterisk (*) 
D)  plus sign (+) 
A)  period (.) 
B)  semicolon (;) 
C)  asterisk (*) 
D)  plus sign (+)

Question 17

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Accepted Answer

A) True 
 B)False

Question 18

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

Accepted Answer

A) True 
 B)False

Question 19

SQL is the acronym for " Simple Query Language ." _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  > 
B)  >= 
C)  >> 
D)  >>= 
A)  > 
B)  >= 
C)  >> 
D)  >>=

Filters are used to select a subset of records in a datasheet.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

The ____ button provides a list of values in the selected field that can be used to customize a filter.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Discuss adding or deleting a table in a query.

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

To move a field in the query design grid, click its ____, and then drag it left or right.

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?

In Access, the Save As command allows you to save either the entire database or the current object with a new name.

You can enter, edit, and navigate data in a query datasheet just like a(n) report datasheet. _________________________

Quotation marks are automatically added to criteria for fields with a Date/Time data type. ____________________

A(n) ____ is a saved object within the datasheet.

Query criteria are not case sensitive.

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

The wildcard character that stands for any group of characters is the ____.

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

SQL is the acronym for " Simple Query Language ." _________________________

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

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

Filters are used to select a subset of records in a datasheet.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

The ____ button provides a list of values in the selected field that can be used to customize a filter.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Discuss adding or deleting a table in a query.

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

To move a field in the query design grid, click its ____, and then drag it left or right.

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?

In Access, the Save As command allows you to save either the entire database or the current object with a new name.

You can enter, edit, and navigate data in a query datasheet just like a(n) report datasheet. _________________________

Quotation marks are automatically added to criteria for fields with a Date/Time data type. ____________________

A(n) ____ is a saved object within the datasheet.

Query criteria are not case sensitive.

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

The wildcard character that stands for any group of characters is the ____.

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

SQL is the acronym for " Simple Query Language ." _________________________

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

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