Question 1

If you use the Top Values option to show the top 5 records and there is a tie for fifth place, the datasheet will display ____.

Accepted Answer

A)  Only four records 
B)  The first four records plus all records that tie for fifth place 
C)  The first four records plus one record for fifth place determined by the value in the key field of the records that tie 
D)  An error message indicating that the Top Values entry must be changed 
A)  Only four records 
B)  The first four records plus all records that tie for fifth place 
C)  The first four records plus one record for fifth place determined by the value in the key field of the records that tie 
D)  An error message indicating that the Top Values entry must be changed

Question 2

All action query icons display a(n) ____ in the icon.

Accepted Answer

A)  Asterisk (*) 
B)  At symbol (@) 
C)  Percent sign (%) 
D)  Exclamation point (!) 
A)  Asterisk (*) 
B)  At symbol (@) 
C)  Percent sign (%) 
D)  Exclamation point (!)

Question 3

Like [Enter the first character of the last name:]& "*" is an example of the Like operator used with parameter criteria. ____________________

Accepted Answer

A) True 
 B)False

Question 4

To prevent running an action query accidentally, use the Run button to view the selected records.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following characters is a wildcard?

Accepted Answer

A)  Ampersand (&) 
B)  Asterisk (*) 
C)  Plus Sign (+) 
D)  Percent Sign (%) 
A)  Ampersand (&) 
B)  Asterisk (*) 
C)  Plus Sign (+) 
D)  Percent Sign (%)

Question 6

Use the Find _________________________ Query Wizard to find records in one table that have the same values in a field.

Accepted Answer

The answer of Use the Find _________________________ Query Wizard to...

Question 7

In the figure above, item 5 refers to the ____ query button.

Accepted Answer

A)  Append 
B)  Delete 
C)  Make Table 
D)  Update 
A)  Append 
B)  Delete 
C)  Make Table 
D)  Update

Question 8

Explain null and zero-length string values.

Accepted Answer

Null is a field value that doe

Question 9

In the figure above, item 6 refers to the ____ query button.

Accepted Answer

A)  Append 
B)  Delete 
C)  Make Table 
D)  Update 
A)  Append 
B)  Delete 
C)  Make Table 
D)  Update

Question 10

Referring to the figure above, explain what records will be selected.

Accepted Answer

Records that have the same val

Question 11

Use the Find _________________________ Query Wizard to find records in one table that do not have matching records in a related table.

Accepted Answer

The answer of Use the Find _________________________ Query Wizard to...

Question 12

In the figure above, item 1 refers to the _________________________ Values list arrow.

Accepted Answer

The answer of   In the figure above, item...

Question 13

Access automatically adds ____ around date criteria.

Accepted Answer

A)  Quotation marks 
B)  Pound signs 
C)  Square brackets 
D)  Asterisks 
A)  Quotation marks 
B)  Pound signs 
C)  Square brackets 
D)  Asterisks

Question 14

A(n) _________________________ query displays a dialog box prompting you for information to enter as limiting criteria each time the query runs.

Accepted Answer

The answer of A(n) _________________________ query displays a dialog box...

Question 15

Explain what a parameter query does.

Accepted Answer

A parameter query displays a dialog box

Question 16

The criteria cell entry: LIKE [Enter the first character of the company name:] & "*" searches for companies that do which of the following?

Accepted Answer

A)  Contain the parameter entry anywhere in the field 
B)  End with the specified letter 
C)  Have only one character 
D)  Begin with the specified character 
A)  Contain the parameter entry anywhere in the field 
B)  End with the specified letter 
C)  Have only one character 
D)  Begin with the specified character

Question 17

In the figure above, item 7 refers to the ____ query button.

Accepted Answer

A)  Append 
B)  Delete 
C)  Make Table 
D)  Update 
A)  Append 
B)  Delete 
C)  Make Table 
D)  Update

Question 18

Enter parameter query criteria in curly brackets. ____________________

Accepted Answer

A) True 
 B)False

Question 19

Explain how to query for null and zero-length string values.

Accepted Answer

Query for zero-length string v

Question 20

If a parameter query prompts and searches for words that contain the entered characters anywhere in the field, then which of the criteria below is the correct one?

Accepted Answer

A)  LIKE [Enter the first character of the last name:] & "*" 
B)  LIKE "*" & [Enter any character(s) to search by:] & "*" 
C)  [Enter start date:] 
D)  None of the above 
A)  LIKE [Enter the first character of the last name:] & "*" 
B)  LIKE "*" & [Enter any character(s) to search by:] & "*" 
C)  [Enter start date:] 
D)  None of the above

If you use the Top Values option to show the top 5 records and there is a tie for fifth place, the datasheet will display ____.

All action query icons display a(n) ____ in the icon.

Like [Enter the first character of the last name:]& "*" is an example of the Like operator used with parameter criteria. ____________________

To prevent running an action query accidentally, use the Run button to view the selected records.

Which of the following characters is a wildcard?

Use the Find _________________________ Query Wizard to find records in one table that have the same values in a field.

In the figure above, item 5 refers to the ____ query button.

Explain null and zero-length string values.

In the figure above, item 6 refers to the ____ query button.

Referring to the figure above, explain what records will be selected.

Use the Find _________________________ Query Wizard to find records in one table that do not have matching records in a related table.

In the figure above, item 1 refers to the _________________________ Values list arrow.

Access automatically adds ____ around date criteria.

A(n) _________________________ query displays a dialog box prompting you for information to enter as limiting criteria each time the query runs.

Explain what a parameter query does.

The criteria cell entry: LIKE [Enter the first character of the company name:] & "*" searches for companies that do which of the following?

In the figure above, item 7 refers to the ____ query button.

Enter parameter query criteria in curly brackets. ____________________

Explain how to query for null and zero-length string values.

If a parameter query prompts and searches for words that contain the entered characters anywhere in the field, then which of the criteria below is the correct one?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 11: Creating Advanced Queries

If you use the Top Values option to show the top 5 records and there is a tie for fifth place, the datasheet will display ____.

All action query icons display a(n) ____ in the icon.

Like [Enter the first character of the last name:]& "*" is an example of the Like operator used with parameter criteria. ____________________

To prevent running an action query accidentally, use the Run button to view the selected records.

Which of the following characters is a wildcard?

Use the Find _________________________ Query Wizard to find records in one table that have the same values in a field.

In the figure above, item 5 refers to the ____ query button.

Explain null and zero-length string values.

In the figure above, item 6 refers to the ____ query button.

Referring to the figure above, explain what records will be selected.

Use the Find _________________________ Query Wizard to find records in one table that do not have matching records in a related table.

In the figure above, item 1 refers to the _________________________ Values list arrow.

Access automatically adds ____ around date criteria.

A(n) _________________________ query displays a dialog box prompting you for information to enter as limiting criteria each time the query runs.

Explain what a parameter query does.

The criteria cell entry: LIKE [Enter the first character of the company name:] & "*" searches for companies that do which of the following?

In the figure above, item 7 refers to the ____ query button.

Enter parameter query criteria in curly brackets. ____________________

Explain how to query for null and zero-length string values.

If a parameter query prompts and searches for words that contain the entered characters anywhere in the field, then which of the criteria below is the correct one?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters