Question 1

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 B

Question 2

Explain the difference between AND and OR criteria.

Accepted Answer

AND: All criteria must be true in order for the record to be selected for a datasheet. The criteria are entered on the same row of the query grid. OR: Any single criterion must be true in order for the record to be selected. The criteria are entered on different rows of the query grid.

Question 3

A join line is also called a(n) ____ line.

Accepted Answer

A)  query 
B)  link 
C)  connection 
D)  objectivity 
A)  query 
B)  link 
C)  connection 
D)  objectivity B

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

Deleting a field from a query also deletes it from the underlying table.

Accepted Answer

A) True 
 B)False

Question 8

To add a table's field list to the upper pane of Query Design View, click the ____________________ Table button on the Design tab.

Accepted Answer

The answer of To add a table's field list to...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

To add, delete, or change fields in a query, you use Query Design View.

Accepted Answer

A) True 
 B)False

Question 12

Discuss adding or deleting a table in a query.

Accepted Answer

You might want to add a table's field li

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 18

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

Accepted Answer

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

Question 19

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 20

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

Accepted Answer

A) True 
 B)False

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

Explain the difference between AND and OR criteria.

A join line is also called a(n) ____ line.

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

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

SQL stands for ____.

Deleting a field from a query also deletes it from the underlying table.

To add a table's field list to the upper pane of Query Design View, click the ____________________ Table button on the Design tab.

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

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

To add, delete, or change fields in a query, you use Query Design View.

Discuss adding or deleting a table in a query.

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

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

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

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

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

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

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

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

Getting Started With Access

Using Forms

Using Reports

Getting Started With Office 2016

Filters

Exam 2: Building and Using Queries

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

Explain the difference between AND and OR criteria.

A join line is also called a(n) ____ line.

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

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

SQL stands for ____.

Deleting a field from a query also deletes it from the underlying table.

To add a table's field list to the upper pane of Query Design View, click the ____________________ Table button on the Design tab.

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

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

To add, delete, or change fields in a query, you use Query Design View.

Discuss adding or deleting a table in a query.

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

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

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

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

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

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

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

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

Getting Started With Access

Using Forms

Using Reports

Getting Started With Office 2016

Filters