Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A calculation resulting in a single value used in update action queries.

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

Question 3

Records deleted using a delete query cannot be restored using the Undo command.

Accepted Answer

A) True 
 B)False

Question 4

Adding indexes to tables speeds up the performance of database operations for large databases.What are the disadvantages of using indexes for large databases.

Accepted Answer

The answer of Adding indexes to tables speeds up the...

Question 5

The abbreviation for a one-to-many relationship.

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

Question 6

A table created using the make-table query will not maintain the primary key designation of the underlying table.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) a primary key field 
B) two primary key fields 
C) all table fields 
D) a common field

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.
-Keisha's supervisor has asked that she provide her with a table showing all of the soccer teams and the team schedules.This table will only be used once to schedule coaches.Which type of query should Keisha run?

Accepted Answer

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

Question 9

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

Accepted Answer

A) date 
B) null 
C) data type 
D) input mask

Question 10

To maintain current data in a table created by an append query,run the query periodically.___________________

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) Make-Table 
B) Action Query 
C) Query Design 
D) Add New

Question 12

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

Accepted Answer

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

Question 13

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

A) 1_tblPatient 
B) tblPatient2 
C) tblPatient_1 
D) 1tblPatient

Question 14

An action query that changes selected field values from selected records in one or more tables.

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

Question 15

Only one existing table may be used in the creation of a delete query.

Accepted Answer

A) True 
 B)False

Question 16

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

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

Question 17

Is it a good idea to save action queries permanently in a database?  Why or why not?

Accepted Answer

The answer of Is it a good idea to save...

Question 18

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

Accepted Answer

A) relationship 
B) index 
C) table 
D) catalog

Question 19

Under what circumstances might it be advisable to delete a database object.

Accepted Answer

The answer of Under what circumstances might it be advisable...

Question 20

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

Exam 9: Using Action Queries and Advanced Table Relationships

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

A calculation resulting in a single value used in update action queries.

Records deleted using a delete query cannot be restored using the Undo command.

Adding indexes to tables speeds up the performance of database operations for large databases.What are the disadvantages of using indexes for large databases.

The abbreviation for a one-to-many relationship.

A table created using the make-table query will not maintain the primary key designation of the underlying table.

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

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

To maintain current data in a table created by an append query,run the query periodically.___________________

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

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?

An action query that changes selected field values from selected records in one or more tables.

Only one existing table may be used in the creation of a delete query.

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.

Is it a good idea to save action queries permanently in a database? Why or why not?

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

Under what circumstances might it be advisable to delete a database object.

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