Question 1

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

Accepted Answer

A many-to-many relationship is implemented using a junction table that has a one-to-many relationship with each of the original tables.

Question 2

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

Accepted Answer

As per the given conditions, 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. This implies that there is a unique correspondence between the records of both tables. Hence, a one-to-one relationship exists between the two tables.

Question 3

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

Accepted Answer

An update query is used to change selected field values from selected records in one or more tables. The other options, delete and append, involve removing or adding entire records rather than just changing specific field values. The select query simply retrieves data from tables.

Question 4

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

Accepted Answer

New tables created with the make-table query retain the data types of the fields from the underlying table(s). Validation rules, formats, and lookup properties are specific to individual fields and are not carried over to the new table.

Question 5

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.

Accepted Answer

The answer of The type of join in a relationship...

Question 6

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.

Accepted Answer

The option described is "Cascade Update Related Fields", which is option D. This option ensures that when the primary key value is changed in the primary table, the appropriate foreign key values in the related table are also updated automatically. This ensures that the relationship between the tables remains intact and there are no errors or inconsistencies in the data.

Question 7

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.

Accepted Answer

An inner join is used when we want to retrieve only the data that has a match in both tables based on a common field. In this case, both tables have a common field with the same value, and therefore an inner join would be appropriate to retrieve the data that satisfies this condition. Outer join retrieves all the data from one table and only the matching data from another table. Self join is used to join a table with itself to produce a result set that joins rows with other rows within the same table using the comparison operators (=, <>, <, <=, >, >=). The term "related join" is not a commonly used term in database management.

Question 8

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

Accepted Answer

Null values are not allowed in a primary key field as it must contain a unique value in each record. Therefore, if the setting for the Primary property is Yes, null values cannot be included in the index. The other options, such as date, data type, and input mask, may be allowed depending on the specific requirements of the primary key field.

Question 9

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

Accepted Answer

A primary key index should be indicated with a setting of "Yes" for the Index Property - Primary, as the primary key serves as a unique identifier for each record in the table and should not allow null values.

Question 10

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

Accepted Answer

In Access 2016, to create an action query, you start by clicking the "Query Design" button from the Create tab. This allows you to design a query, which can then be converted into an action query like Make-Table, Update, Append, or Delete.

Question 11

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

Accepted Answer

In the Design view, you can add the same table twice and create a relationship between them. This is required for creating a self-join. In Datasheet view, you cannot create or modify relationships, and in SQL or Properties view, you can only view or modify existing relationships.

Question 12

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

Accepted Answer

An "append" query adds records from existing tables or queries to the end of another table. "Make-table" query creates a new table, "SQL" is a programming language mainly used for managing databases and "delete" query removes records from a table.

Question 13

A(n)____ query creates a new table that is a combination of fields and records from two or more tables.

Accepted Answer

A make-table query creates a new table by combining fields and records from two or more tables. This query is useful for creating a temporary table that can then be used in other queries or reports. The other options (update, append, SQL) do not create a new table by combining data from multiple tables.

Question 14

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

Accepted Answer

Field values related to records are typically organized in tables and indexed to allow for efficient searching and retrieval of information. A relationship refers to the way in which tables are linked together, and a catalog is a listing of all the tables and other objects in a database. Therefore, the most appropriate answer is B, index.

Question 15

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

Accepted Answer

In a many-to-many relationship, the relationship table (also known as a junction table) contains a composite primary key made up of the primary keys from the two tables it connects, ensuring each pair of values is unique.

Question 16

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

Accepted Answer

The answer of A relationship that joins a table to...

Question 17

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

Accepted Answer

The Join Types button is available in the Edit Relationships dialog box, where you can change the type of join between tables.

Question 18

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

Accepted Answer

The answer of Select all fields in a table to...

Question 19

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?

Accepted Answer

Using "tblPatient_1" indicates that the table is a duplicate of "tblPatient" and is being used in a self-join relationship. Adding the underscore and number makes it clear that it is a separate entity and distinguishes it from the first instance of the table. Option A and D are not recommended as they do not follow naming conventions and may cause issues with querying the table. Option B could be confusing as it does not explicitly indicate that it is a duplicate table.

Question 20

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

Accepted Answer

A one-to-many relationship is formed when a common field is used to join two tables. The table on the one side of the relationship will have a unique value in the common field, but the table on the many side may have multiple rows with the same value in the common field. Therefore, a common field is the best choice for forming a one-to-many relationship.

Quiz 9: Using Action Queries and Advanced Table Relationships

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

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

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

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

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

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.

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

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

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

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

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

A(n) ____ query creates a new table that is a combination of fields and records from two or more tables.

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

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

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

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

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

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?

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