FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Using Action Queries and Advanced Table Relationships

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) C) and D)
F) A) and D)

Correct Answer

verified

Show Answer

Question 2

Matching

Review LaterAdd Note

Review Later

Matching

Premises

Responses

An action query that adds records from existing tables or queries to the end of another table.

primary table

1:M

1:1

M:N

action query

append query

update query

history table

expression

delete query

Premises

An action query that adds records from existing tables or queries to the end of another table.

Responses

primary table

1:M

1:1

M:N

action query

append query

update query

history table

expression

delete query

Show Answer

Correct Answer

Premises

Responses

primary table

1:M

1:1

M:N

action query

append query

update query

history table

expression

delete query

Premises

primary table

1:M

1:1

M:N

action query

append query

update query

history table

expression

delete query

Responses

Question 3

Multiple Choice

Review LaterAdd Note

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

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?

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

Matching

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?

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

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

Matching

Matching

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

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

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

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

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(n) ____ value is not allowed in an index if the setting for the Primary property is Yes.

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

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.