Question 1

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

Accepted Answer

When a database object is no longer need

Question 2

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

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 4

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 5

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 6

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

Accepted Answer

The Answer of M:N and delete query and 1:M and is...

Question 7

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 8

Match between columns
                        Premises: A table that always has a one-to-many relationship with a relationship table.

Accepted Answer

The Answer of delete query and action query and primary is...

Question 9

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

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 12

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

Accepted Answer

The Answer of M:N and expression and update query and is...

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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

Question 18

A primary key index is indicated when the Index Property - Primary - has a setting of ____.

Accepted Answer

A) Yes 
B) No 
C) Allow Nulls 
D) Ignore Nulls 
A) Yes 
B) No 
C) Allow Nulls 
D) Ignore Nulls

Question 19

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 20

All indexes for a table may be viewed by clicking on the Indexes button in the Show/Hide group on the Design tab.

Accepted Answer

A) True 
 B)False

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

A multiple-field index must be created using ____.

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

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

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 index may be added to or deleted from tables at any time except for primary key indexes.

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

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

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

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

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

A primary key index is indicated when the Index Property - Primary - has a setting of ____.

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

All indexes for a table may be viewed by clicking on the Indexes button in the Show/Hide group on the Design tab.

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters

Exam 9: Using Action Queries and Advanced Table Relationships

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

A multiple-field index must be created using ____.

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

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

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 index may be added to or deleted from tables at any time except for primary key indexes.

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

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

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

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

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

A primary key index is indicated when the Index Property - Primary - has a setting of ____.

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

All indexes for a table may be viewed by clicking on the Indexes button in the Show/Hide group on the Design tab.

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters