Exam 9: Using Action Queries and Advanced Table Relationships

Many-to-many relationships are created using a third table that forms ____ relationships with the two original primary tables.

Which of the following table names would appear in Design view to indicate a table being used in a self-join relationship and distinguish it from the first instance of the table in the relationship?

To quickly access the Join Properties dialog box, right-click the join line between two tables in Design view. ____________________

An append query overwrites an existing query with new data.

In the design grid of an append query, the ____ row identifies the fields that the query will append to the table that was designated.

Only one existing table may be used in the creation of a delete query.

Case-Based Critical Thinking Questions Case 9-1 Keisha is completing an internship with the local parks and recreation department.  She has been asked to update and maintain the beginning soccer league database for children ages 3-4.  The league consists of over 150 children and 10 soccer teams.  The teams play at two different soccer fields in the city.  The database already exists from last year so Keisha will not be developing the database.  She will only make changes as necessary to the current database. -After the first week of beginning soccer, some children have decided not to continue playing and children on the wait list have been added to teams with openings.  What type of query would help Keisha add the new players to her current Participant table?

____ queries are often used to append records to history tables.

Access databases may only contain one-to-one relationships 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. -The relationship between the Bus Number and Bus Routes tables is one-to-many which means that each Bus Number record is related to ____ Bus Routes record(s).

A table created using the make-table query will not maintain the primary key designation of the underlying 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. -A join that relates records from the Bus Number table with the Bus Routes table based on the same Bus ID is an example of a(n)____ join.

When a new table is created using a make-table query, selected fields and records are not deleted from the existing table.

The type of join in a relationship that selects all records from one table and only the records from a second table that have matching common field values is a(n)____ join.