Question 1

Join types may be changed using the Join Types button available in the ____ dialog box.

Accepted Answer

A) Query Tools 
B) Properties 
C) Join Wizard 
D) Edit Relationships 
A) Query Tools 
B) Properties 
C) Join Wizard 
D) Edit Relationships

Question 2

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

Accepted Answer

A) Datasheet 
B) Design 
C) SQL 
D) Properties 
A) Datasheet 
B) Design 
C) SQL 
D) Properties

Question 3

A table that contains data that is no longer needed but that might need to be referenced in the future.

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 4

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

Accepted Answer

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

Question 5

The only field that is automatically indexed by AutoIndex settings is the primary key field.____________________

Accepted Answer

A) True 
 B)False

Question 6

In the design grid of an append query,the ____ row identifies the fields that the query will append to the table that was designated.

Accepted Answer

A) Show 
B) Field 
C) Append To 
D) Criteria 
A) Show 
B) Field 
C) Append To 
D) Criteria

Question 7

It is not recommended that a select query be created before creating a make-table query.

Accepted Answer

A) True 
 B)False

Question 8

A make-table query is a(n)____ query that creates a new table by copying records from one or more existing tables.

Accepted Answer

A) SQL 
B) select 
C) action 
D) cross-tab 
A) SQL 
B) select 
C) action 
D) cross-tab

Question 9

A query that adds,changes,or deletes multiple table records.

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 10

An index may be added to or deleted from tables at any time except for primary key indexes.

Accepted Answer

A) True 
 B)False

Question 11

Access databases may only contain one-to-one relationships between tables.____________________

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) a single field 
B) multiple fields 
C) a single query 
D) multiple data types 
A) a single field 
B) multiple fields 
C) a single query 
D) multiple data types

Question 13

An action query that deletes a group of records matching the criteria specified in Design view from 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 14

To quickly access the Join Properties dialog box,right-click the join line between two tables in Design view.____________________

Accepted Answer

A) True 
 B)False

Question 15

Text expressions included in the Update To row of an update query should always be enclosed in quotation marks.____________________

Accepted Answer

A) True 
 B)False

Join types may be changed using the Join Types button available in the ____ dialog box.

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

A table that contains data that is no longer needed but that might need to be referenced in the future.

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

The only field that is automatically indexed by AutoIndex settings is the primary key field.____________________

In the design grid of an append query,the ____ row identifies the fields that the query will append to the table that was designated.

It is not recommended that a select query be created before creating a make-table query.

A make-table query is a(n)____ query that creates a new table by copying records from one or more existing tables.

A query that adds,changes,or deletes multiple table records.

An index may be added to or deleted from tables at any time except for primary key indexes.

Access databases may only contain one-to-one relationships between tables.____________________

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

An action query that deletes a group of records matching the criteria specified in Design view from one or more tables.

To quickly access the Join Properties dialog box,right-click the join line between two tables in Design view.____________________

Text expressions included in the Update To row of an update query should always be enclosed in quotation marks.____________________

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

Join types may be changed using the Join Types button available in the ____ dialog box.

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

A table that contains data that is no longer needed but that might need to be referenced in the future.

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

The only field that is automatically indexed by AutoIndex settings is the primary key field.____________________

In the design grid of an append query,the ____ row identifies the fields that the query will append to the table that was designated.

It is not recommended that a select query be created before creating a make-table query.

A make-table query is a(n)____ query that creates a new table by copying records from one or more existing tables.

A query that adds,changes,or deletes multiple table records.

An index may be added to or deleted from tables at any time except for primary key indexes.

Access databases may only contain one-to-one relationships between tables.____________________

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

An action query that deletes a group of records matching the criteria specified in Design view from one or more tables.

To quickly access the Join Properties dialog box,right-click the join line between two tables in Design view.____________________

Text expressions included in the Update To row of an update query should always be enclosed in quotation marks.____________________

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