Question 1

Field values related to records that contain those field values may be listed in a(n) ____.

Accepted Answer

A)  relationship 
B)  index 
C)  table 
D)  catalog

Question 2

To test an action query before running the query, it is a good practice to create a ____________________ first to make sure the correct records are selected.

Accepted Answer

The answer of To test an action query before running...

Question 3

Match between columns
                        Premises: A query that adds, changes, or deletes multiple table records.

Accepted Answer

The Answer of action query and history table and expression is...

Question 4

Is it a good idea to save action queries permanently in a database?  Why or why not?

Accepted Answer

The answer of Is it a good idea to save...

Question 5

A make-table query is a(n) ____ query that creates a new table by copying records from one or more existing tables.

Accepted Answer

A)  SQL 
B)  select 
C)  action 
D)  cross-tab

Question 6

Cascade options between related tables are available only when ____________________ is enabled.

Accepted Answer

The answer of Cascade options between related tables are available...

Question 7

Case-Based Critical Thinking Questions Case 9-3
Taylor manages a database for a regional hardware enterprise with 10 stores in 2 states.  The hardware store wholesales to contractors. The database includes these tables (among others): tblContractor, tblProducts, tblBilling, tblInvoices.
Taylor has added the tables tblContractor, tblBilling, and tblInvoices to the relationships window. He has created a relationship between the tblBilling and tblContractor based on the ContractorID field.  What type of relationship is this?

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  one-to-none

Question 8

Text expressions included in the Update To row of an update query should always be enclosed in quotation marks . ____________________

Accepted Answer

A) True 
 B)False

Question 9

The default join type for table relationships in Access is a(n) ____ join.

Accepted Answer

A)  inner 
B)  self 
C)  outer 
D)  append

Question 10

Records deleted using a delete query cannot be restored using the Undo command.

Accepted Answer

A) True 
 B)False

Question 11

In an auto parts inventory database, one car manufacturer may have many auto parts, and a part may be used for many different vehicle models. This is an example of a(n) ____ relationship.

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many

Question 12

A new table created by a(n) ____ query may contain a subset of the fields and records in an existing table.

Accepted Answer

A)  append 
B)  make-table 
C)  delete 
D)  update

Question 13

An action query that changes selected field values from selected records in one or more tables is a(n) ____ query.

Accepted Answer

A)  update 
B)  delete 
C)  append 
D)  select

Question 14

The ____ and ____ query types give the user an option to modify data in the Current Database or Another Database using the query dialog box.

Accepted Answer

A)  append, delete 
B)  append, make-table 
C)  make-table, delete 
D)  delete, update

Question 15

The third table created for a many-to-many relationship is called a(n) ____________________ table.

Accepted Answer

The answer of The third table created for a many-to-many...

Question 16

A(n) ____ value is not allowed in an index if the setting for the Primary property is Yes.

Accepted Answer

A)  date 
B)  null 
C)  data type 
D)  input mask

Question 17

Match between columns
                        Premises: An action query that adds records from existing tables or queries to the end of another table.

Accepted Answer

The Answer of update query and history table and 1:M is...

Question 18

To maintain current data in a table created by an append query, run the query periodically. ___________________

Accepted Answer

A) True 
 B)False

Question 19

Inner, outer, and self are all types of queries .

Accepted Answer

A) True 
 B)False

Question 20

When creating a self-join relationship it is necessary to add the same table to the Relationship window twice in ____ view.

Accepted Answer

A)  Datasheet 
B)  Design 
C)  SQL 
D)  Properties

Exam 10: Using Action Queries and Advanced Table Relationships

Field values related to records that contain those field values may be listed in a(n) ____.

To test an action query before running the query, it is a good practice to create a ____________________ first to make sure the correct records are selected.

Match the followings.

Is it a good idea to save action queries permanently in a database? Why or why not?

A make-table query is a(n) ____ query that creates a new table by copying records from one or more existing tables.

Cascade options between related tables are available only when ____________________ is enabled.

Text expressions included in the Update To row of an update query should always be enclosed in quotation marks . ____________________

The default join type for table relationships in Access is a(n) ____ join.

Records deleted using a delete query cannot be restored using the Undo command.

In an auto parts inventory database, one car manufacturer may have many auto parts, and a part may be used for many different vehicle models. This is an example of a(n) ____ relationship.

A new table created by a(n) ____ query may contain a subset of the fields and records in an existing table.

An action query that changes selected field values from selected records in one or more tables is a(n) ____ query.

The and query types give the user an option to modify data in the Current Database or Another Database using the query dialog box.

The third table created for a many-to-many relationship is called a(n) ____________________ table.

A(n) ____ value is not allowed in an index if the setting for the Primary property is Yes.

Match the followings.

To maintain current data in a table created by an append query, run the query periodically. ___________________

Inner, outer, and self are all types of queries .

When creating a self-join relationship it is necessary to add the same table to the Relationship window twice in ____ view.