Question 1

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 2

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

Accepted Answer

A)  0 
B)  Is Not Null 
C)  *=* 
D)  * * 
A)  0 
B)  Is Not Null 
C)  *=* 
D)  * *

Question 3

You can enter, edit, and navigate data in a query datasheet just like a(n) report 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 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)  Near 
A)  Find 
B)  Like 
C)  Search 
D)  Near

Question 5

To move fields in the query grid, drag the field ____________________.

Accepted Answer

The answer of To move fields in the query grid,...

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

The record selector button is to the right of a record in a datasheet.

Accepted Answer

A) True 
 B)False

Question 9

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

Accepted Answer

A)  filter 
B)  query 
C)  grid 
D)  sort 
A)  filter 
B)  query 
C)  grid 
D)  sort

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

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 13

The bottom button in the accompanying figure ____.

Accepted Answer

A)  sorts records in descending order 
B)  sorts records in ascending order 
C)  helps you navigate to the first, previous, next, last, or new record 
D)  removes the current sort order 
A)  sorts records in descending order 
B)  sorts records in ascending order 
C)  helps you navigate to the first, previous, next, last, or new record 
D)  removes the current sort order

Question 14

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Accepted Answer

A) True 
 B)False

Question 15

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

Accepted Answer

The answer of In Query Design View, the query design...

Question 16

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 17

In Query Design View, record selectors are thin gray bars above the field names in the query grid.

Accepted Answer

A) True 
 B)False

Question 18

In the accompanying figure, StateName and StateAbbreviation appear in the States ____ list.

Accepted Answer

A)  title 
B)  field 
C)  category 
D)  entry 
A)  title 
B)  field 
C)  category 
D)  entry

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

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

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?

To move fields in the query grid, drag the field ____________________.

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

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

The record selector button is to the right of a record in a datasheet.

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

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

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

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

The bottom button in the accompanying figure ____.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

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

In Query Design View, record selectors are thin gray bars above the field names in the query grid.

In the accompanying figure, StateName and StateAbbreviation appear in the States ____ list.

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

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

Getting Started With Access 2013

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters

Exam 2: Building and Using Queries

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

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

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

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?

To move fields in the query grid, drag the field ____________________.

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

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

The record selector button is to the right of a record in a datasheet.

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

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

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

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

The bottom button in the accompanying figure ____.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

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

In Query Design View, record selectors are thin gray bars above the field names in the query grid.

In the accompanying figure, StateName and StateAbbreviation appear in the States ____ list.

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

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

Getting Started With Access 2013

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters