Question 1

A prompt query displays a dialog box that prompts you for field criteria. ____________________

Accepted Answer

A) True 
 B)False

Question 2

Explain null and zero-length string values.

Accepted Answer

Null is a field value that doe

Question 3

Explain what a parameter query does.

Accepted Answer

A parameter query displays a dialog box

Question 4

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 5

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Accepted Answer

A) True 
 B)False

Question 6

The Alias property renames a field list in Query Design View. ____________________

Accepted Answer

A) True 
 B)False

Question 7

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 8

A(n) _________________________ query is one that makes changes to the data. There are several types of these queries.

Accepted Answer

The answer of A(n) _________________________ query is one that makes...

Question 9

A backup is a copy of the database that you could use if an error occurs in the current database that cannot be fixed. ____________________

Accepted Answer

A) True 
 B)False

Question 10

The _____ property renames a field list in Query Design View.

Accepted Answer

A)  Alias 
B)  Description 
C)  Document 
D)  Alternate 
A)  Alias 
B)  Description 
C)  Document 
D)  Alternate

Question 11

Which action query would you use if you wanted to remove product records that are discontinued from a Products table?

Accepted Answer

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

Question 12

Which action query would you use if you wanted to export records to another Access database?

Accepted Answer

A)  Make-Table 
B)  Top Values 
C)  Update 
D)  Delete 
A)  Make-Table 
B)  Top Values 
C)  Update 
D)  Delete

Question 13

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

You can build a form or report based on a parameter query. ____________________

Accepted Answer

A) True 
 B)False

Question 16

In Query Design View, the asterisk in the field list represents all the fields in the table.

Accepted Answer

A) True 
 B)False

Question 17

Action queries select but do not change data.

Accepted Answer

A) True 
 B)False

Question 18

If a parameter query prompts and searches for dates on or after the entered date, then which of the criteria below is the correct one?

Accepted Answer

A)  LIKE [Enter start date:] 
B)  LIKE [Enter start date and end date:] 
C)  >=[Enter start date:] and 
D)  None of the above 
A)  LIKE [Enter start date:] 
B)  LIKE [Enter start date and end date:] 
C)  >=[Enter start date:] and 
D)  None of the above

Question 19

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

Accepted Answer

duplicates

Question 20

Read/write is the default value for the Recordset Type property which allows you to update data. ____________________

Accepted Answer

A) True 
 B)False

A prompt query displays a dialog box that prompts you for field criteria. ____________________

Explain null and zero-length string values.

Explain what a parameter query does.

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

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

The Alias property renames a field list in Query Design View. ____________________

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

A(n) _________________________ query is one that makes changes to the data. There are several types of these queries.

A backup is a copy of the database that you could use if an error occurs in the current database that cannot be fixed. ____________________

The _____ property renames a field list in Query Design View.

Which action query would you use if you wanted to remove product records that are discontinued from a Products table?

Which action query would you use if you wanted to export records to another Access database?

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

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

You can build a form or report based on a parameter query. ____________________

In Query Design View, the asterisk in the field list represents all the fields in the table.

Action queries select but do not change data.

If a parameter query prompts and searches for dates on or after the entered date, then which of the criteria below is the correct one?

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

Read/write is the default value for the Recordset Type property which allows you to update data. ____________________

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

A prompt query displays a dialog box that prompts you for field criteria. ____________________

Explain null and zero-length string values.

Explain what a parameter query does.

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

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

The Alias property renames a field list in Query Design View. ____________________

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

A(n) _________________________ query is one that makes changes to the data. There are several types of these queries.

A backup is a copy of the database that you could use if an error occurs in the current database that cannot be fixed. ____________________

The _____ property renames a field list in Query Design View.

Which action query would you use if you wanted to remove product records that are discontinued from a Products table?

Which action query would you use if you wanted to export records to another Access database?

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

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

You can build a form or report based on a parameter query. ____________________

In Query Design View, the asterisk in the field list represents all the fields in the table.

Action queries select but do not change data.

If a parameter query prompts and searches for dates on or after the entered date, then which of the criteria below is the correct one?

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

Read/write is the default value for the Recordset Type property which allows you to update data. ____________________

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