Exam 10: Using Action Queries and Advanced Table Relationships

Join types may be changed using the Join Types button available in the ____ dialog box.

It is not recommended that a select query be created before creating a make-table query.

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.

In the accompanying figure, the Join Properties dialog box shows the ____ join type option selected.

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

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

A multiple-field index must be created using ____.

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

Two tables joined using a common field forming a one-to-many relationship allow the two tables to be used for other database objects as if they are one large table.

In the accompanying figure, arrow #3 indicates the icon that represents a(n) ____ query.

In the accompanying figure, the PartID field is the ____.

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

In the accompanying figure, arrow #2 indicates an icon representing a(n) ____ query.

An append query overwrites an existing query with new data.

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

A query that performs actions on the data in tables in a database is considered a(n) ____________________ query.

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

In the query design grid for a(n) ____________________ query, the Show and Sort rows are replaced with the Update To row.

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

A table created using the make-table query will not maintain the primary key designation of the underlying table.