Question 1

To access the Edit Relationships dialog box from a shortcut menu, ____ the join line between tables.
A) click and drag
B) delete
C) left-click
D) right-click

Accepted Answer

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

Question 2

Records deleted using a Delete query may not be restored by using the ____ command.
A) Redo
B) Undo
C) Unhide
D) Select

Accepted Answer

The Undo command is used to reverse the most recent action performed in Access, including deleting records using a Delete query. It is not possible to restore the deleted records using Redo, Unhide, or Select commands.

Question 3

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

The naming convention for a self-join relationship is to add an underscore and a number to the end of the table name to distinguish it from the first instance of the table in the relationship. Therefore, option C of tblPatient_1 is the best choice for indicating a self-join relationship.

Question 4

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, null values are not allowed in the index.

Question 5

In the accompanying figure, which field is the foreign key in the tblBilling table?
A) InvoiceNum
B) VisitID
C) EmployeeID
D) PatientID

Accepted Answer

A foreign key is a field that references the primary key of another table. In this case, VisitID in the tblBilling table refers to the primary key (VisitID) of tblVisit. Therefore, B is the foreign key in the tblBilling table.

Question 6

A multiple-field index must be created using ____.
A) the Field Properties pane
B) the Data Type drop-down list
C) a subdata sheet
D) the Indexes dialog box

Accepted Answer

The Indexes dialog box allows for the creation of a multiple-field index, which can be accessed by selecting the "Create Index" button and specifying the fields to include in the index. The Field Properties pane and Data Type drop-down list do not have the specific functionality to create a multiple-field index. A subdata sheet is a way to display related records within a record and is not applicable to creating an index.

Question 7

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) Show
B) Field
C) Append To
D) Criteria

Accepted Answer

The Append To row in the design grid of an append query identifies the fields that the query will append to the table that was designated. The Show row is used to specify which fields to display in the results, the Field row is used to specify the table and fields to use in the query, and the Criteria row is used to set conditions for the query.

Question 8

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 9

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) append, delete
B) append, make-table
C) make-table, delete
D) delete, update

Accepted Answer

The append query type adds records from one table to another, allowing the user to modify data by choosing which fields to include and applying criteria. The make-table query type creates a new table based on a query's results and allows the user to modify data by choosing which fields to include and applying criteria. The delete query type removes records from a table and does not allow for modification of data. The update query type changes the values of specific fields in a table and does not give the user the option to modify data in another database. Therefore, the best choice is B, as it includes both the append and make-table query types that allow the user to modify data in the Current Database or Another Database using the query dialog box.

Question 10

The default join type for table relationships in Access is a(n) ____ join.
A) inner
B) self
C) outer
D) append

Accepted Answer

The default join type in Access is an inner join, which only includes records that have matching values in both tables being joined.

Question 11

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 12

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

In the accompanying figure, the Join Properties dialog box shows the ____ join type option selected.
A) outer
B) self-join
C) inner
D) referential

Accepted Answer

The Join Properties dialog box shows the inner join type option selected. There are no null values in either table, and only the matching values from both tables will be included in the resulting join.

Question 14

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

When creating a self-join relationship, it is necessary to add the same table to the Relationship window twice in Design view. This allows for the creation of a relationship between two different instances of the same table.

Question 15

A new table created by a(n) ____ query may contain a subset of the fields and records in an existing table.
A) append
B) make-table
C) delete
D) update

Accepted Answer

A make-table query creates a new table with a subset of the fields and records from an existing table. Append query adds (appends) new records to an existing table. Delete query deletes records from an existing table. Update query updates values in an existing table.

Question 16

Use the Field Properties pane to create an index for ____.
A) a single field
B) multiple fields
C) a single query
D) multiple data types

Accepted Answer

The Field Properties pane allows for creating an index for a single field.

Question 17

In the accompanying figure, to define a one-to-many relationship between the tblBilling and tblTreatment tables, the ____ common field should be used.
A) EmployeeID
B) VisitID
C) InvoiceNum
D) InvoicePaid

Accepted Answer

The answer of  In the accompanying figure, to define...

Question 18

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 related to records are indexed so that they can be quickly and easily searched and sorted. Therefore, the field values would be listed in the index. A relationship describes the connection between two tables, a table contains records, and a catalog typically refers to a collection of information about a particular subject or product.

Question 19

The choice to enforce referential integrity is indicated in Design view by a thick ____
A) border around the table name
B) border around the primary key of the primary table
C) join line
D) red join line

Accepted Answer

The answer of The choice to enforce referential integrity is...

Question 20

In an auto parts inventory database, one car manufacturer may have many auto parts, and a part may be used for many different vehicle models. This is an example of a(n) ____ relationship.
A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Accepted Answer

The scenario described is an example of a many-to-many relationship, where one car manufacturer can have many auto parts and a single auto part can be used in different vehicle models.

Quiz 10: Using Action Queries and Advanced Table Relationships

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

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

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) ____ value is not allowed in an index if the setting for the Primary property is Yes.

In the accompanying figure, which field is the foreign key in the tblBilling table?

A multiple-field index must be created using ____.

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.

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

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.

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

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

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

A new table created by a(n) ____ query may contain a subset of the fields and records in an existing table.

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

In the accompanying figure, to define a one-to-many relationship between the tblBilling and tblTreatment tables, the ____ common field should be used.

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

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

In an auto parts inventory database, one car manufacturer may have many auto parts, and a part may be used for many different vehicle models. This is an example of a(n) ____ relationship.