Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

____ 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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Discuss adding or deleting a table in a query.

Accepted Answer

The answer of Discuss adding or deleting a table in...

Question 5

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

Accepted Answer

The answer of One way to create a new query...

Question 6

SQL is the acronym for " Simple Query Language ."

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

SQL stands for ____.

Accepted Answer

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

Question 9

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

Question 10

Match between columns
                        Premises: Used to search for a pattern

Accepted Answer

The Answer of query and wildcard and sorting and Is is...

Question 11

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

Question 12

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 13

When you double-click a field in a field list in Query Design View, it is ____.

Accepted Answer

A)  deleted from the query 
B)  added to the next available position in the query design grid 
C)  used as the first sort order 
D)  set as the primary key field

Question 14

Match between columns
                        Premises: The lower pane in Query Design View

Accepted Answer

The Answer of datasheet and Is Null and sorting and is...

Question 15

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Query Design View presents the fields you can use for a query in small windows called field ____.

Accepted Answer

A)  glossaries 
B)  lists 
C)  links 
D)  catalogs

Question 18

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 19

Is ____________________ criteria will find all records where no entry has been made in the field.

Accepted Answer

The answer of Is ____________________ criteria will find all records...

Question 20

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Exam 2: Building and Using Queries

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

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

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

Discuss adding or deleting a table in a query.

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

SQL is the acronym for " Simple Query Language ."

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.

SQL stands for ____.

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

Match each term with the statement that best describes it.

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

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

When you double-click a field in a field list in Query Design View, it is ____.

Match each term with the statement that best describes it.

A query can be used to create calculated fields.

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

Query Design View presents the fields you can use for a query in small windows called field ____.

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

Is ____________________ criteria will find all records where no entry has been made in the field.

A filter can be used to create calculated fields.