Question 1

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

Accepted Answer

A)  Criteria 
B)  Filters 
C)  Queries 
D)  none of the above

Question 2

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 3

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

Accepted Answer

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

Question 4

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.

Accepted Answer

The answer of The ____________________ button provides filter features such...

Question 5

To sort records based on the selected field in the order Z to A, use the _____ button.

Accepted Answer

A)  Down 
B)  Descending 
C)  Z to A 
D)  Reverse Sort

Question 6

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 7

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 8

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

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 10

To find numbers greater than or equal to 500, use which comparison operator?

Accepted Answer

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

Question 11

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 12

Match between columns
                        Premises: The lower pane in Query Design View
Limiting conditions used to narrow the number of records on a datasheet
Used to search for a pattern
Creates a datasheet of selected fields and records from one or more tables
Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines
Putting records in ascending or descending order based on a field's values
Creates a temporary subset of records
Criterion that finds all records where no entry has been made in the field

Accepted Answer

The Answer of query and Is Null and criteria and is...

Question 13

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

Accepted Answer

A)  criteria 
B)  posts 
C)  versioning 
D)  indices

Question 14

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 15

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

Question 16

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 17

The question mark (?) is the wildcard character which stands for any single character in criteria.

Accepted Answer

A) True 
 B)False

Question 18

A(n) ____________________ answers a question about the information in the database.

Accepted Answer

The answer of A(n) ____________________ answers a question about the...

Question 19

To make a page wider than it is tall, use landscape orientation. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 2: Building and Using Queries

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

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

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

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.

To sort records based on the selected field in the order Z to A, use the _____ button.

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

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

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

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

To find numbers greater than or equal to 500, use which comparison operator?

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.

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

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

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

A filter can be used to create calculated fields.

The question mark (?) is the wildcard character which stands for any single character in criteria.

A(n) ____________________ answers a question about the information in the database.

To make a page wider than it is tall, use landscape orientation. _________________________

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