Question 1

To enter a long criterion in Query Design View, right-click the Criteria cell, then click Zoom . ____________________

Accepted Answer

A) True 
 B)False

Question 2

The term blank describes a field value that does not exist because it has never been entered. ______________________

Accepted Answer

A) True 
 B)False

Question 3

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

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

When you click the Delete button from the Query Type list, the _________________________ row is added to the query design grid.

Accepted Answer

The answer of When you click the Delete button from...

Question 6

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 7

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

Accepted Answer

Query for zero-length string v

Question 8

Match between columns
                        Premises: Creates a new table from all or part of the data in one or more tables
Changes all selected records
Adds a group of records from one or more tables to another table
Removes a group of records from one or more tables
Makes global changes to the values in a field

Accepted Answer

The Answer of Update query and Append query and Action is...

Question 9

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 10

Which of the following is a valid parameter criterion?

Accepted Answer

A)  >=Type date here 
B)  >=(Type date here:) 
C)  >={Type date here} 
D)  >=[Type date here:] 
A)  >=Type date here 
B)  >=(Type date here:) 
C)  >={Type date here} 
D)  >=[Type date here:]

Question 11

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 12

Double-clicking an action query in the Navigation Pane runs the query.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Which button do you use to complete an action query?

Accepted Answer

A)  View 
B)  Select 
C)  Show 
D)  Run 
A)  View 
B)  Select 
C)  Show 
D)  Run

Question 15

To enter a long criterion, right-click the Criteria cell then click Expand . ____________________

Accepted Answer

A) True 
 B)False

Question 16

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 17

For Select queries, the Datasheet View button and the Run button do the same thing.

Accepted Answer

A) True 
 B)False

Question 18

The Top Values feature creates summarized calculations on groups of records.

Accepted Answer

A) True 
 B)False

Question 19

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 20

A table has a(n) _________________________ record when information in the foreign key field of the "many" table doesn't have a matching entry in the primary key field.

Accepted Answer

The answer of A table has a(n) _________________________ record when...

To enter a long criterion in Query Design View, right-click the Criteria cell, then click Zoom . ____________________

The term blank describes a field value that does not exist because it has never been entered. ______________________

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

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

When you click the Delete button from the Query Type list, the _________________________ row is added to the query design grid.

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

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

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

Which of the following is a valid parameter criterion?

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

Double-clicking an action query in the Navigation Pane runs the query.

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

Which button do you use to complete an action query?

To enter a long criterion, right-click the Criteria cell then click Expand . ____________________

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

For Select queries, the Datasheet View button and the Run button do the same thing.

The Top Values feature creates summarized calculations on groups of records.

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

A table has a(n) _________________________ record when information in the foreign key field of the "many" table doesn't have a matching entry in the primary key field.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 10: Creating Advanced Queries

To enter a long criterion in Query Design View, right-click the Criteria cell, then click Zoom . ____________________

The term blank describes a field value that does not exist because it has never been entered. ______________________

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

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

When you click the Delete button from the Query Type list, the _________________________ row is added to the query design grid.

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

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

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

Which of the following is a valid parameter criterion?

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

Double-clicking an action query in the Navigation Pane runs the query.

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

Which button do you use to complete an action query?

To enter a long criterion, right-click the Criteria cell then click Expand . ____________________

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

For Select queries, the Datasheet View button and the Run button do the same thing.

The Top Values feature creates summarized calculations on groups of records.

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

A table has a(n) _________________________ record when information in the foreign key field of the "many" table doesn't have a matching entry in the primary key field.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters