Question 1

Which of the following comparison operators means "less than or equal to"?

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

Accepted Answer

The answer of ____________________ a table or query datasheet temporarily...

Question 6

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 7

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 8

A query datasheet is sometimes called a ____ of the data.

Accepted Answer

A)  logical view 
B)  duplicate copy 
C)  table simulator 
D)  warehouse 
A)  logical view 
B)  duplicate copy 
C)  table simulator 
D)  warehouse

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

Accepted Answer

A)  fix 
B)  post 
C)  freeze 
D)  view 
A)  fix 
B)  post 
C)  freeze 
D)  view

Question 12

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 13

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 Form 
A)  Syntax 
B)  Formatting 
C)  Sorting 
D)  Filter by Form

Question 14

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

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  data 
B)  queries 
C)  tables 
D)  all of the above 
A)  data 
B)  queries 
C)  tables 
D)  all of the above

Question 18

Query criteria are not case sensitive.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Compare the capabilities of queries and filters.

Accepted Answer

* Queries are saved as objects in the da

Which of the following comparison operators means "less than or equal to"?

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

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

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

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

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

A query datasheet is sometimes called a ____ of the data.

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

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

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

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.

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

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

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

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

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

Query criteria are not case sensitive.

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

Compare the capabilities of queries and filters.

Getting Started With Access

Using Forms

Using Reports

Getting Started With Office 2016

Filters

Exam 2: Building and Using Queries

Which of the following comparison operators means "less than or equal to"?

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

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

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

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

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

A query datasheet is sometimes called a ____ of the data.

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

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

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

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.

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

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

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

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

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

Query criteria are not case sensitive.

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

Compare the capabilities of queries and filters.

Getting Started With Access

Using Forms

Using Reports

Getting Started With Office 2016

Filters