Exam 10: Using Action Queries and Advanced Table Relationships

When creating an append query, selected fields in the query must match the fields in the table to which the records will be appended. ____________________

Under what circumstances might it be advisable to delete a database object.

A query type may be changed from the Query Type group on the DESIGN tab in ____________________ view.

An index may be added to or deleted from tables at any time except for primary key indexes.

Adding indexes to tables speeds up the performance of database operations for large databases. What are the disadvantages of using indexes for large databases.

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

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

In a query based on an inner join, a foreign key with a(n) ____________________ value will eliminate that record from the query recordset.

Two tables related by a common field with the same value in the common field in each table is an example of a(n) ____ join.

To create an action query, click the ____ button from the Create tab in Access 2013.

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

When creating an append query, the Append To row replaces the ____________________ row in Design view.

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?

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. Keisha's supervisor has asked that she provide her with a table showing all of the soccer teams and the team schedules.  This table will only be used once to schedule coaches.  Which type of query should Keisha run?

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

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

A(n) ____ query creates a new table that is a combination of fields and records from two or more tables.

Access databases may only contain one-to-one relationships between tables. ____________________

The only field that is automatically indexed by AutoIndex settings is the primary key field. ____________________

In a many-to-many relationship the relationship table will contain two ____________________ keys.