Exam 10: Using Action Queries and Advanced Table Relationships

Use the Field Properties pane to create an index for ____.

A one-to-many relationship is formed when two tables are joined using ____.

Select all fields in a table to add to a query design grid by double clicking the ____ of the table field list.

The default join type for Access when creating relationships between tables is the ____________________ join.

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

When each record in the primary table matches zero, one, or more records in the related table, and when each record in the related table matches at most one record in the primary table, a(n) ____________________ relationship exists.

In a table relationship, the ____ option requires Access to change the appropriate foreign key values in the related table when the primary key value is changed in the primary table.

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

In the accompanying figure, to define a one-to-many relationship between the tblBilling and tblTreatment tables, the ____ common field should be used.

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.

It is not possible to verify a Join Type once a relationship has been established between two tables.

In Design view, the Delete row replaces the ____________________ row(s) in the design grid when creating 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. Parents of some of the beginning soccer players have requested that their children be moved to a team that plays at the field closest to their home.  To modify the team field in the current Beginner Soccer League database, Keisha can run a(n) ____ query.

New tables created with the make-table query retain the field ____ of the underlying table(s).

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

The type of relationship between two tables when each record in the first table matches many records in the second table, and each record in the second table matches many records in the first table, is a(n) ____________________ relationship.