Exam 9: Using Action Queries and Advanced Table Relationships

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.

Records deleted using a delete query cannot be restored using the Undo command.

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.

An action query that changes selected field values from selected records in one or more tables is a(n)____ query.

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

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.

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

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

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.

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

Case-Based Critical Thinking Questions Case 9-3 Taylor manages a database for a regional hardware enterprise with 10 stores in 2 states.  The hardware store wholesales to contractors. The database includes these tables (among others): tblContractor, tblProducts, tblBilling, tblInvoices. -Taylor wants to create a query that shows all contractors and identifies invoices assigned to those contractors.  However, he also wants to see contractors who might not have an invoice assigned for this billing period.  What type of join between tables will give Taylor the desired results?

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.

The ____ and ____ query types give the user an option to modify data in the Current Database or Another Database using the query dialog box.

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

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

An action query can only modify one record in a table at a time.

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

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

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