Question 1

Access saves ____ automatically as you move from record to record.

Accepted Answer

A)  data 
B)  queries 
C)  tables 
D)  all of the above

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

Quotation marks are automatically added to criteria for fields with a Date/Time data type.​

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

Query criteria are not case sensitive.​

Accepted Answer

A) True 
 B)False

Question 10

Explain the difference between AND and OR criteria.

Accepted Answer

The answer of Explain the difference between AND and OR...

Question 11

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 12

Match between columns
                        Premises: Creates a datasheet of selected fields and records from one or more tables

Accepted Answer

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

Question 13

A query datasheet is sometimes called a ____ of the data.

Accepted Answer

A)  logical view 
B)  duplicate copy 
C)  table simulator 
D)  warehouse

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

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 16

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Accepted Answer

The answer of Filter By ____________________ is a fast and...

Question 17

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 18

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

Accepted Answer

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

Question 19

Match between columns
                        Premises: Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

Accepted Answer

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

Question 20

The wildcard character that stands for any single character is the ____.

Accepted Answer

A)  ampersand (&) 
B)  question mark (?) 
C)  exclamation mark (!) 
D)  caret (^)

Exam 2: Building and Using Queries

Access saves ____ automatically as you move from record to record.

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

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

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

Quotation marks are automatically added to criteria for fields with a Date/Time data type.

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

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

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

Query criteria are not case sensitive.

Explain the difference between AND and OR criteria.

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

Match each term with the statement that best describes it.

A query datasheet is sometimes called a ____ of the data.

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

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

Filter By ____________________ is a fast and easy way to filter records for an exact match.

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

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

Match each term with the statement that best describes it.

The wildcard character that stands for any single character is the ____.

Exam 2: Building and Using Queries

Access saves ____ automatically as you move from record to record.

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

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

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

Quotation marks are automatically added to criteria for fields with a Date/Time data type.​

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

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

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

Query criteria are not case sensitive.​

Explain the difference between AND and OR criteria.

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

Match each term with the statement that best describes it.

A query datasheet is sometimes called a ____ of the data.

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

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

Filter By ____________________ is a fast and easy way to filter records for an exact match.

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

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

Match each term with the statement that best describes it.

The wildcard character that stands for any single character is the ____.

Quotation marks are automatically added to criteria for fields with a Date/Time data type.

Query criteria are not case sensitive.

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