Access Tutorial 9

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

Field values related to records that contain those field values may be listed in a(n) ____.

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

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

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

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

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

In a table relationship, the ____ option requires Access to delete all records in the related table that have a foreign key value related to the primary table when a record is deleted in the primary 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. 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.

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.

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.

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

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

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

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 has added the tables tblContractor, tblBilling, and tblInvoices to the relationships window. He has created a relationship between the tblBilling and tblContractor based on the ContractorID field. What type of relationship is this?

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

A(n) ____ value is not allowed in an index if the setting for the Primary property is Yes. Select one:

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

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

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

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

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

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

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

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

The choice to enforce referential integrity is indicated in Design view by a thick ____

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.

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?

Text expressions included in the Update To row of an update query should always be enclosed in quotation marks.

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

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

Access databases may only contain one-to-one relationships between 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.

When a new table is created using a make-table query, selected fields and records are not deleted from the existing 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 Bus Routes tables is one-to-many which means that each Bus Number record is related to ____ Bus Routes record(s).

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

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

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

When creating a self-join relationship it is necessary to add the same table to the Relationship window twice in ____ view.

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

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

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.

To maintain current data in a table created by an append query, run the query periodically.

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

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?

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?

Many-to-many relationships are created using a third table that forms ____ relationships with the two original primary tables.