Question 1

Join types may be changed using the Join Types button available in the ____ dialog box.
A)Query Tools
B)Properties
C)Join Wizard
D)Edit Relationships

Accepted Answer

The answer of Join types may be changed using the...

Question 2

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.
A)inner
B)outer
C)self
D)relational

Accepted Answer

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

Question 3

New tables created with the make-table query retain the field ____ of the underlying table(s).
A)data type
B)validation rule
C)format
D)lookup properties

Accepted Answer

When creating a new table with a make-table query, the new table will inherit the data types of the fields from the underlying table(s). The validation rule, format, and lookup properties will not carry over to the new table unless specifically defined in the query.

Question 4

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)inner
B)outer
C)self
D)related

Accepted Answer

This describes an inner join, which only returns matching records from both tables based on the common field value.

Question 5

A primary key index is indicated when the Index Property - Primary - has a setting of ____.
A)Yes
B)No
C)Allow Nulls
D)Ignore Nulls

Accepted Answer

A primary key index is created when the Index Property - Primary is set to "Yes". This indicates that the index is unique and identifies each record in the table.

Question 6

A one-to-many relationship is formed when two tables are joined using ____.
A)a primary key field
B)two primary key fields
C)all table fields
D)a common field

Accepted Answer

A one-to-many relationship is formed when one table's primary key is referenced as a foreign key in another table. This common field links the rows in the two tables, creating a one-to-many relationship. Therefore, the correct choice is D - a common field.

Question 7

The relationship table in a(n)____ relationship contains a primary key that is a composite key with a unique pair of values.
A)one-to-one
B)one-to-many
C)many-to-many
D)many-to-one

Accepted Answer

A many-to-many relationship requires a relationship table, and the primary key in this table must be a composite key made up of the primary keys from the two related tables. This composite key ensures that each combination of related records is unique.

Question 8

To create an action query, click the ____ button from the Create tab in Access 2016.
A)Make-Table
B)Action Query
C)Query Design
D)Add New

Accepted Answer

The answer of To create an action query, click the...

Question 9

A relationship that joins a table to itself is a(n)____ join type.
A)inner
B)outer
C)self
D)related

Accepted Answer

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

Question 10

Field values related to records that contain those field values may be listed in a(n)____.
A)relationship
B)index
C)table
D)catalog

Accepted Answer

Field values are often indexed to improve the performance of searching or sorting through large amounts of data. The index contains a sorted list of all the field values and the record identifiers that contain them. This allows for faster access to the records that contain a particular value. Therefore, the best choice is index.

Question 11

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.
A)Edit Relationships
B)Enforce Referential Integrity
C)Cascade Delete Related Records
D)Cascade Update Related Fields

Accepted Answer

The Cascade Update Related Fields option allows Access to automatically update the foreign key values in the related table if the primary key value is changed in the primary table. This ensures data consistency and accuracy in the database.

Question 12

An action query that changes selected field values from selected records in one or more tables is a(n)____ query.
A)update
B)delete
C)append
D)select

Accepted Answer

An update query is used to modify or update the values of selected records in one or more tables. It allows you to change the value of one or more fields based on specified criteria. The other options, delete and append, are also types of action queries, but they do not involve changing the values of existing fields in selected records. Select query is not an action query, it is used to retrieve and display data from one or more tables.

Question 13

Select all fields in a table to add to a query design grid by double clicking the ____ of the table field list.
A)field names
B)title bar
C)property sheet
D)primary key

Accepted Answer

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

Question 14

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
A)one-to-one
B)one-to-many
C)many-to-many
D)many-to-one

Accepted Answer

A one-to-one relationship exists 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. This means that there is a unique and singular relationship between the two tables, making it a one-to-one relationship.

Question 15

When creating a self-join relationship it is necessary to add the same table to the Relationship window twice in ____ view.
A)Datasheet
B)Design
C)SQL
D)Properties

Accepted Answer

The Design view allows for the creation and editing of table relationships, including self-joins where a table is related to itself. In Design view, the same table can be added twice and linked by a common field/column. This allows for queries and reports to be created using the self-joined table to analyze data relationships within the same table.

Question 16

A(n)____ value is not allowed in an index if the setting for the Primary property is Yes.
A)date
B)null
C)data type
D)input mask

Accepted Answer

If the Primary property is set to Yes, then a null value is not allowed in the index. This is because null values are not considered unique and cannot be used as a primary key. Therefore, option B - null - is the correct choice.

Question 17

A(n)____ query adds records form existing tables or queries to the end of another table.
A)make-table
B)SQL
C)delete
D)append

Accepted Answer

An "append" query is used to add records from existing tables or queries to the end of another table. It is also known as an "insert" query. A "make-table" query creates a new table based on the records retrieved from tables or queries. "SQL" is a programming language used to manage relational databases. "Delete" query is used to remove records from a table.

Question 18

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)1_tblPatient
B)tblPatient2
C)tblPatient_1
D)1tblPatient

Accepted Answer

Using underscore and a number (e.g. "tblPatient_1") is commonly used in databases to indicate a self-join relationship and distinguish it from the first instance of the table in the relationship. The other options either start with a number (which is not recommended) or have numbers in the middle or end of the name, which may not clearly indicate a self-join relationship.

Question 19

A(n)____ query creates a new table that is a combination of fields and records from two or more tables.
A)update
B)make-table
C)append
D)SQL

Accepted Answer

A make-table query creates a new table by selecting fields from one or more existing tables and inserting the selected data into the new table. This is often used for creating temporary tables or consolidating data from multiple sources. Update queries change the values of existing records, append queries add new records to existing tables, and SQL is a programming language used to interact with databases.

Question 20

Many-to-many relationships are created using a third table that forms ____ relationships with the two original primary tables.
A)many-to-one
B)one-to-many
C)many-to-many
D)one-to-one

Accepted Answer

The answer of Many-to-many relationships are created using a third...

Quiz 9: Using Action Queries and Advanced Table Relationships

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

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.

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

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 primary key index is indicated when the Index Property - Primary - has a setting of ____.

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

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

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

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

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

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.

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

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

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

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

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

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

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(n) ____ query creates a new table that is a combination of fields and records from two or more tables.

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