Question 1

-In the figure above, item 6 refers to the ____ query button.

Accepted Answer

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

Question 2

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

orphan

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

-In the figure above, item 5 refers to the ____ query button.

Accepted Answer

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

Question 5

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 6

-In the figure above, item 4 refers to the ____ query icon.

Accepted Answer

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

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

-In the figure above, what Top Values option is chosen?

Accepted Answer

A)  Top 5 
B)  Top 100 
C)  Top 5% 
D)  All 
A)  Top 5 
B)  Top 100 
C)  Top 5% 
D)  All

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

Which query criteria are equivalent to "Marketing" ?

Accepted Answer

A)  "marketing" 
B)  "MARKETING" 
C)  "mArKeTiNg" 
D)  All of the above 
A)  "marketing" 
B)  "MARKETING" 
C)  "mArKeTiNg" 
D)  All of the above

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

-In the figure above, what does item 2 toggle on and off?

Accepted Answer

A)  Criteria row 
B)  Totals row 
C)  Show row 
D)  Sort row 
A)  Criteria row 
B)  Totals row 
C)  Show row 
D)  Sort row

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?

Accepted Answer

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

Question 18

-Referring to the figure above, explain what records will be selected.

Accepted Answer

Records that have the same val

Question 19

-Referring to the figure above, describe what you would do to show all of the records in the Enrollments table even if there were no related Courses records.

Accepted Answer

Click opti

Question 20

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

Accepted Answer

A)  1813 
B)  1913 
C)  2013 
D)  You must type 4 digits for year data. 
A)  1813 
B)  1913 
C)  2013 
D)  You must type 4 digits for year data.

-In the figure above, item 6 refers to the ____ query button.

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.

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

-In the figure above, item 5 refers to the ____ query button.

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

-In the figure above, item 4 refers to the ____ query icon.

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

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

-In the figure above, what Top Values option is chosen?

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

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

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

Which query criteria are equivalent to "Marketing" ?

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

-In the figure above, what does item 2 toggle on and off?

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

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?

-Referring to the figure above, explain what records will be selected.

-Referring to the figure above, describe what you would do to show all of the records in the Enrollments table even if there were no related Courses records.

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

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

-In the figure above, item 6 refers to the ____ query button.

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.

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

-In the figure above, item 5 refers to the ____ query button.

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

-In the figure above, item 4 refers to the ____ query icon.

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

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

-In the figure above, what Top Values option is chosen?

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

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

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

Which query criteria are equivalent to "Marketing" ?

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

-In the figure above, what does item 2 toggle on and off?

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

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?

-Referring to the figure above, explain what records will be selected.

-Referring to the figure above, describe what you would do to show all of the records in the Enrollments table even if there were no related Courses records.

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

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