Question 1

-Refer to the figure above. What type of join would be created if you clicked option 2?

Accepted Answer

The answer of  
-Refer to the figure above. What...

Question 2

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

Accepted Answer

A)  1931 
B)  2031 
C)  1831 
D)  You must type all 4 digits for a year. 
A)  1931 
B)  2031 
C)  1831 
D)  You must type all 4 digits for a year.

Question 3

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

Accepted Answer

A) True 
 B)False

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

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

-In the figure above, which field is being grouped?

Accepted Answer

A)  Enrollments 
B)  EnrollmentID 
C)  Description 
D)  CourseID 
A)  Enrollments 
B)  EnrollmentID 
C)  Description 
D)  CourseID

Question 8

The Description property appears on the Database Documenter reports. ____________________

Accepted Answer

A) True 
 B)False

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

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

Question 11

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 <=[Enter end date:] D) None of the above A) LIKE [Enter start date:] B) LIKE [Enter start date and end date:] C) >=[Enter start date:] and <=[Enter end date:] D) None of the above

Question 12

Explain null and zero-length string values.

Accepted Answer

Null is a field value that doe

Question 13

If you modify a field's properties in Table Design View, they are modified for the entire database.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Enter parameter query criteria in curly brackets. ____________________

Accepted Answer

A) True 
 B)False

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

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 18

In a one-to-many relationship with referential integrity, the "one" table contains ____ records and the "many" table contains ____ records.

Accepted Answer

A)  parent ~ child 
B)  orphan ~ parent 
C)  orphan ~ child 
D)  child ~ parent 
A)  parent ~ child 
B)  orphan ~ parent 
C)  orphan ~ child 
D)  child ~ parent

Question 19

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 20

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

-Refer to the figure above. What type of join would be created if you clicked option 2?

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

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

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

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

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

-In the figure above, which field is being grouped?

The Description property appears on the Database Documenter reports. ____________________

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

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

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?

Explain null and zero-length string values.

If you modify a field's properties in Table Design View, they are modified for the entire database.

Which of the following is a valid parameter criterion?

Enter parameter query criteria in curly brackets. ____________________

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

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

In a one-to-many relationship with referential integrity, the "one" table contains records and the "many" table contains records.

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

Access automatically adds ____ around date criteria.

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

-Refer to the figure above. What type of join would be created if you clicked option 2?

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

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

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

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

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

-In the figure above, which field is being grouped?

The Description property appears on the Database Documenter reports. ____________________

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

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

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?

Explain null and zero-length string values.

If you modify a field's properties in Table Design View, they are modified for the entire database.

Which of the following is a valid parameter criterion?

Enter parameter query criteria in curly brackets. ____________________

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

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

In a one-to-many relationship with referential integrity, the "one" table contains ____ records and the "many" table contains ____ records.

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

Access automatically adds ____ around date criteria.

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

In a one-to-many relationship with referential integrity, the "one" table contains records and the "many" table contains records.