Question 1

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

Accepted Answer

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

Question 2

An action query changes data as soon as the type of action query is chosen from the Query Type list.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

If you type the last 2 digits of a year as 13, such as 1/1/17, Access assumes that they signify:

Accepted Answer

A)  1817 
B)  1917 
C)  2017 
D)  You must type 4 digits for year data. 
A)  1817 
B)  1917 
C)  2017 
D)  You must type 4 digits for year data.

Question 6

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 7

The _____ property allows you to better document the purpose or author of a query.

Accepted Answer

A)  Author 
B)  Description 
C)  Document 
D)  Purpose 
A)  Author 
B)  Description 
C)  Document 
D)  Purpose

Question 8

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 9

When you run an action query Access prompts you with an "Are you sure?" message before actually changing the data.

Accepted Answer

A) True 
 B)False

Question 10

You can keep an action query in the Navigation Pane but hide it using the Action property. ____________________

Accepted Answer

A) True 
 B)False

Question 11

The ____ entry in the Recordset Type property locks the recordset.

Accepted Answer

A)  Snapshot 
B)  Dynaset 
C)  Dataset 
D)  Lockset 
A)  Snapshot 
B)  Dynaset 
C)  Dataset 
D)  Lockset

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

An action query changes data as soon as the type of action query is chosen from the Query Type list.

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?

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

If you type the last 2 digits of a year as 13, such as 1/1/17, Access assumes that they signify:

Which of the following characters is a wildcard?

The _____ property allows you to better document the purpose or author of a query.

Access automatically adds ____ around date criteria.

When you run an action query Access prompts you with an "Are you sure?" message before actually changing the data.

You can keep an action query in the Navigation Pane but hide it using the Action property. ____________________

The ____ entry in the Recordset Type property locks the recordset.

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

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

An action query changes data as soon as the type of action query is chosen from the Query Type list.

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?

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

If you type the last 2 digits of a year as 13, such as 1/1/17, Access assumes that they signify:

Which of the following characters is a wildcard?

The _____ property allows you to better document the purpose or author of a query.

Access automatically adds ____ around date criteria.

When you run an action query Access prompts you with an "Are you sure?" message before actually changing the data.

You can keep an action query in the Navigation Pane but hide it using the Action property. ____________________

The ____ entry in the Recordset Type property locks the recordset.

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