Exam 9: Using Action Queries and Advanced Table Relationships

A table that always has a one-to-many relationship with a relationship table.

The relationship table in a(n)____ relationship contains a primary key that is a composite key with a unique pair of values.

The default join type for table relationships in Access is a(n)____ join.

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.

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.

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.

The abbreviation for a one-to-one relationship.

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

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

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.

When each record in the first table matches at most one record in the second table,and each record in the second table matches at most one record in the first table,a(n)____ relationship exists between the two tables

The abbreviation for a many-to-many relationship.

A relationship that joins a table to itself is a(n)____ join type.

All indexes for a table may be viewed by clicking on the Indexes button in the Show/Hide group on the Design tab.

A primary key index is indicated when the Index Property - Primary - has a setting of ____.

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

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 does not want information about beginning soccer players from the past year in the Beginner Soccer League database for the current year.She may run a(n)____ query with selected criteria such as year and team name to remove last year's players.

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

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