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.

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.

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

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

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

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.

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?

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 .

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