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

1.Indexing tables adds disk st

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

Student answers will vary but should inc

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 
A) relationship 
B) index 
C) table 
D) catalog

Question 19

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

Accepted Answer

When a database object is no longer need

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

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.

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

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.

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