Question 1

In the accompanying figure, arrow #1 indicates an icon representing a(n) ____ query.

Accepted Answer

A)  make-table 
B)  append 
C)  delete 
D)  update 
A)  make-table 
B)  append 
C)  delete 
D)  update

Question 2

A table with a primary key that is a foreign key to a second table and whose fields are additional fields for the second table is a(n) ____________________.

Accepted Answer

The answer of A table with a primary key that...

Question 3

Match between columns
                        Premises: A table that contains data that is no longer needed but that might need to be referenced in the future.

Accepted Answer

The Answer of 1:1 and history table and delete query is...

Question 4

Match between columns
                        Premises: The abbreviation for a one-to-many relationship.

Accepted Answer

The Answer of M:N and update query and primary table is...

Question 5

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

Accepted Answer

A)  border around the table name 
B)  border around the primary key of the primary table 
C)  join line 
D)  red join line 
A)  border around the table name 
B)  border around the primary key of the primary table 
C)  join line 
D)  red join line

Question 6

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

A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one 
A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one

Question 7

In the accompanying figure, arrow #1 indicates an icon representing a select query. ____________________

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

A)  inner 
B)  outer 
C)  self 
D)  relational 
A)  inner 
B)  outer 
C)  self 
D)  relational

Question 10

An index is automatically created by Access for the ____________________ in a table.

Accepted Answer

The answer of An index is automatically created by Access...

Question 11

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

Accepted Answer

A)  InvoiceNum 
B)  VisitID 
C)  EmployeeID 
D)  PatientID 
A)  InvoiceNum 
B)  VisitID 
C)  EmployeeID 
D)  PatientID

Question 12

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.
After the first week of beginning soccer, some children have decided not to continue playing and children on the wait list have been added to teams with openings.  What type of query would help Keisha add the new players to her current Participant table?

Accepted Answer

A)  make-table 
B)  append 
C)  delete 
D)  update 
A)  make-table 
B)  append 
C)  delete 
D)  update

Question 13

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

Accepted Answer

A)  many-to-one 
B)  one-to-many 
C)  many-to-many 
D)  one-to-one 
A)  many-to-one 
B)  one-to-many 
C)  many-to-many 
D)  one-to-one

Question 14

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

Accepted Answer

A)  inner 
B)  outer 
C)  self 
D)  related 
A)  inner 
B)  outer 
C)  self 
D)  related

Question 15

In the accompanying figure, the join indicated by the green arrow shows which type of relationship between the two tables?

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one 
A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one

Question 16

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.

Accepted Answer

A)  Edit Relationships 
B)  Enforce Referential Integrity 
C)  Cascade Delete Related Records 
D)  Cascade Update Related Fields 
A)  Edit Relationships 
B)  Enforce Referential Integrity 
C)  Cascade Delete Related Records 
D)  Cascade Update Related Fields

Question 17

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

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one 
A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one

Question 18

Match between columns
                        Premises: A calculation resulting in a single value used in update action queries.

Accepted Answer

The Answer of 1:1 and expression and action query and is...

Question 19

Match between columns
                        Premises: The abbreviation for a many-to-many relationship.

Accepted Answer

The Answer of 1:M and primary table and expression and is...

Question 20

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?

Accepted Answer

A)  inner join 
B)  outer join 
C)  self-join 
D)  many-to-many 
A)  inner join 
B)  outer join 
C)  self-join 
D)  many-to-many

In the accompanying figure, arrow #1 indicates an icon representing a(n) ____ query.

A table with a primary key that is a foreign key to a second table and whose fields are additional fields for the second table is a(n) ____________________.

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

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

In the accompanying figure, arrow #1 indicates an icon representing a select query. ____________________

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

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.

An index is automatically created by Access for the ____________________ in a table.

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

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

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

In the accompanying figure, the join indicated by the green arrow shows which type of relationship between the two 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.

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 10: Using Action Queries and Advanced Table Relationships

In the accompanying figure, arrow #1 indicates an icon representing a(n) ____ query.

A table with a primary key that is a foreign key to a second table and whose fields are additional fields for the second table is a(n) ____________________.

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

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

In the accompanying figure, arrow #1 indicates an icon representing a select query. ____________________

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

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.

An index is automatically created by Access for the ____________________ in a table.

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

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

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

In the accompanying figure, the join indicated by the green arrow shows which type of relationship between the two 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.

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters