Question 1

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 2

This kind of operator selects all records between 2 specified values.

Accepted Answer

A)  Find Unmatched 
B)  Make Table 
C)  Between...And 
D)  Yes/No 
A)  Find Unmatched 
B)  Make Table 
C)  Between...And 
D)  Yes/No

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

In the figure above, which field is being counted?

Accepted Answer

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

Question 6

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

Accepted Answer

The Courses and Enrollments ta

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

Action queries select but do not change data.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

The Like operator is used with the asterisk wildcard in query criteria. ____________________

Accepted Answer

A) True 
 B)False

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

This kind of operator selects all records between 2 specified values.

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

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

In the figure above, which field is being counted?

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

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

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

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

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 is a valid parameter criterion?

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

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?

Action queries select but do not change data.

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

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

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

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

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

The Like operator is used with the asterisk wildcard in query criteria. ____________________

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 11: Creating Advanced Queries

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

This kind of operator selects all records between 2 specified values.

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

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

In the figure above, which field is being counted?

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

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

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

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

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 is a valid parameter criterion?

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

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?

Action queries select but do not change data.

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

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

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

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

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

The Like operator is used with the asterisk wildcard in query criteria. ____________________

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

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