Question 1

A filter can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 2

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 3

____________________ 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 4

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

Question 5

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

Accepted Answer

A) True 
 B)False

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

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 8

The accompanying figure shows the query in ____ View.

Accepted Answer

A)  Criteria 
B)  Design 
C)  Field 
D)  None of the above 
A)  Criteria 
B)  Design 
C)  Field 
D)  None of the above

A filter can be used to create calculated fields.

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.

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

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

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

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

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

The accompanying figure shows the query in ____ View.

Getting Started With Access 2013

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters

Exam 2: Building and Using Queries

A filter can be used to create calculated fields.

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.

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

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

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

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

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

The accompanying figure shows the query in ____ View.

Getting Started With Access 2013

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters