Question 1

Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?

Accepted Answer

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

Question 2

It is wise to make a current backup of the database before running any action query.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is NOT a type of action query?

Accepted Answer

A)  Select 
B)  Delete 
C)  Update 
D)  Make-table 
A)  Select 
B)  Delete 
C)  Update 
D)  Make-table

Question 4

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

-The datasheet shown in the figure above sorts records on the EnrollmentID field.

Accepted Answer

A) True 
 B)False

Question 6

Match each term with the best choice.
-Changes all selected records

Accepted Answer

A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query 
A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query

Question 7

-In the figure above, how will the records be presented?

Accepted Answer

A)  Smallest to largest by count of EnrollmentID 
B)  Largest to smallest by count of EnrollmentID 
C)  Smallest to largest group by Description 
D)  Largest to smallest group by Description 
A)  Smallest to largest by count of EnrollmentID 
B)  Largest to smallest by count of EnrollmentID 
C)  Smallest to largest group by Description 
D)  Largest to smallest group by Description

Question 8

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

Question 9

Which action query would you use if you wanted to add records from one table to a backup table?

Accepted Answer

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

Question 10

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 11

You can build a form or report based on a parameterquery. ____________________

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

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

Accepted Answer

Query for zero-length string v

Question 14

Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?

Accepted Answer

A)  [Enter the first character of the company name:] is the parameter prompt. 
B)  & is the wildcard. 
C)  "*" is the second parameter prompt. 
D)  All of the above. 
A)  [Enter the first character of the company name:] is the parameter prompt. 
B)  & is the wildcard. 
C)  "*" is the second parameter prompt. 
D)  All of the above.

Question 15

Parameter criteria are always entered within ____.

Accepted Answer

A) (Parentheses) B) {Curly brackets} C) [Square brackets] D) A) (Parentheses) B) {Curly brackets} C) [Square brackets] D)

Question 16

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

Accepted Answer

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

Question 17

Click the VIEW tab on the ribbon to create a backup. ____________________

Accepted Answer

A) True 
 B)False

Question 18

If you wish to increase the price of a product in a particular category by 10%, you could use a(n) ____ query.

Accepted Answer

A)  Select 
B)  Make-table 
C)  Append 
D)  Update 
A)  Select 
B)  Make-table 
C)  Append 
D)  Update

Question 19

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 20

-Referring to the figure above, what is the relationship between the Courses and Enrollments tables?

Accepted Answer

The Courses and Enrollments ta

Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?

It is wise to make a current backup of the database before running any action query.

Which of the following is NOT a type of action query?

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

-The datasheet shown in the figure above sorts records on the EnrollmentID field.

Match each term with the best choice. -Changes all selected records

-In the figure above, how will the records be presented?

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

Which action query would you use if you wanted to add records from one table to a backup table?

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

You can build a form or report based on a parameterquery. ____________________

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?

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

Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?

Parameter criteria are always entered within ____.

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

Click the VIEW tab on the ribbon to create a backup. ____________________

If you wish to increase the price of a product in a particular category by 10%, you could use a(n) ____ query.

Which of the following characters is a wildcard?

-Referring to the figure above, what is the relationship between the Courses and Enrollments tables?

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 12: Creating Advanced Queries

Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?

It is wise to make a current backup of the database before running any action query.

Which of the following is NOT a type of action query?

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

-The datasheet shown in the figure above sorts records on the EnrollmentID field.

Match each term with the best choice. -Changes all selected records

-In the figure above, how will the records be presented?

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

Which action query would you use if you wanted to add records from one table to a backup table?

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

You can build a form or report based on a parameterquery. ____________________

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?

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

Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?

Parameter criteria are always entered within ____.

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

Click the VIEW tab on the ribbon to create a backup. ____________________

If you wish to increase the price of a product in a particular category by 10%, you could use a(n) ____ query.

Which of the following characters is a wildcard?

-Referring to the figure above, what is the relationship between the Courses and Enrollments tables?

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters