Question 1

To access the Edit Relationships dialog box from a shortcut menu, ____ the join line between tables.

Accepted Answer

A)  click and drag
B)  delete
C)  left-click
D)  right-click D

Question 2

Case-Based Critical Thinking Questions
Case 9-2
Latham works in the logistics department for a large city bus system.  As routes are changed, Latham accesses the internal database to ensure all records are accurate.  The Bus Route System database includes a one-to-many relationship between the Bus Number and the Bus Routes with Bus ID as the common field.  This allows the two tables to be joined to create a query based on data from both tables:  Bus Number and Bus Routes.
-Latham often has to look up bus routes based on specific bus stops.  To speed up the search process in this large database, he might want to create a(n)____ for the Bus Stop field in the Bus Routes table.

Accepted Answer

A)  update query
B)  outer join
C)  index
D)  self-join C

Question 3

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 B

Question 4

Case-Based Critical Thinking Questions
Case 9-2
Latham works in the logistics department for a large city bus system.  As routes are changed, Latham accesses the internal database to ensure all records are accurate.  The Bus Route System database includes a one-to-many relationship between the Bus Number and the Bus Routes with Bus ID as the common field.  This allows the two tables to be joined to create a query based on data from both tables:  Bus Number and Bus Routes.
-The relationship between the Bus Number and the Bus Routes tables is one-to-many which means that each Bus Route record is connected to _____ Bus Number record(s).

Accepted Answer

A)  at most one
B)  at least one
C)  exactly one
D)  zero, one, or more

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

Match between columns
                        Premises: A table that contains data that is no longer needed but that might need to be referenced in the future.

Accepted Answer

The Answer of history table and 1:M and primary table is...

Question 7

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 8

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 9

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 10

Records deleted using a Delete query are permanently removed from the database when the database is ____.

Accepted Answer

A)  closed
B)  opened
C)  compacted
D)  saved

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: The abbreviation for a many-to-many relationship.

Accepted Answer

The Answer of primary table and 1:1 and action query is...

Question 13

Match between columns
                        Premises: The abbreviation for a one-to-many relationship.

Accepted Answer

The Answer of primary table and action query and 1:M is...

Question 14

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 primary table and 1:M and 1:1 and is...

Question 15

Remove a table from the Query window by right-clicking in the field list and choosing delete table. ___________________

Accepted Answer

A) True 
 B)False

Question 16

A(n)____ query adds records form existing tables or queries to the end of another table.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Records deleted using a Delete query may not be restored by using the ____ command.

Accepted Answer

A)  Redo
B)  Undo
C)  Unhide
D)  Select

Question 19

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 20

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

Exam 9: Using Action Queries and Advanced Table Relationships

To access the Edit Relationships dialog box from a shortcut menu, ____ the join line between tables.

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

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

Matching

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

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

Records deleted using a Delete query are permanently removed from the database when the database is ____.

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

Matching

Matching

Matching

Remove a table from the Query window by right-clicking in the field list and choosing delete table. ___________________

A(n) ____ query adds records form existing tables or queries to the end of another table.

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

Records deleted using a Delete query may not be restored by using the ____ 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.

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