Question 1

Inner,outer,and self are all types of queries.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

An append query overwrites an existing query with new data.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) field names 
B) title bar 
C) property sheet 
D) primary key 
A) field names 
B) title bar 
C) property sheet 
D) primary key

Question 6

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?

Accepted Answer

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

Question 7

An action query that adds records from existing tables or queries to the end of another table.

Accepted Answer

A) append query 
B) delete query 
C) M:N 
D) primary table 
E) 1:M
F)update query
G)action query
H)1:1
I)expression
J)history table 
A) append query 
B) delete query 
C) M:N 
D) primary table 
E) 1:M
F)update query
G)action query
H)1:1
I)expression
J)history table

Question 8

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) update 
B) delete 
C) append 
D) select 
A) update 
B) delete 
C) append 
D) select

Question 11

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

Accepted Answer

A) at most one 
B) at least one 
C) exactly one 
D) zero,one,or more 
A) at most one 
B) at least one 
C) exactly one 
D) zero,one,or more

Question 12

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.

Accepted Answer

A) True 
 B)False

Question 13

A multiple-field index must be created using ____.

Accepted Answer

A) the Field Properties pane 
B) the Data Type drop-down list 
C) a subdata sheet 
D) the Indexes dialog box 
A) the Field Properties pane 
B) the Data Type drop-down list 
C) a subdata sheet 
D) the Indexes dialog box

Question 14

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

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 15

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

Accepted Answer

A) data type 
B) validation rule 
C) format 
D) lookup properties 
A) data type 
B) validation rule 
C) format 
D) lookup properties

Question 16

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.
-Parents of some of the beginning soccer players have requested that their children be moved to a team that plays at the field closest to their home.To modify the team field in the current Beginner Soccer League database,Keisha can run a(n)____ query.

Accepted Answer

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

Question 17

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.

Accepted Answer

A) update query 
B) outer join 
C) index 
D) self-join 
A) update query 
B) outer join 
C) index 
D) self-join

Question 18

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

Accepted Answer

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

Question 19

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

Question 20

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

Inner,outer,and self are all types of queries.

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

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

An append query overwrites an existing query with new data.

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

An action query that adds records from existing tables or queries to the end of another table.

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

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

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.

A multiple-field index must be created using ____.

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.

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

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

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

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 Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 9: Using Action Queries and Advanced Table Relationships

Inner,outer,and self are all types of queries.

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

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

An append query overwrites an existing query with new data.

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

An action query that adds records from existing tables or queries to the end of another table.

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

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

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.

A multiple-field index must be created using ____.

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.

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

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

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

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 Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

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