Access Quiz 9

What does a delete query do?

A delete query deletes a group of records from one or more tables based on one or more conditions.

outer join

A join between two tables in which the DBMS selects all records from one table and only those records from the second table that have matching common field values. (AC 526)

inner join

A join between two tables in which the DBMS selects records from the tables only when the records have the same value in the common field that links the tables. (AC 525)

index

A list that relates field values to the records that contain those values. (AC 534)

What is the difference between a make-table query and an append query?

A make-table query creates a new table from one or more existing tables. An append query adds records from existing tables or queries to the end of another table.

Action query

A query that adds, changes, or deletes multiple table records at a time. (AC 500)

one-to-one relationship (1:1)

A relationship between two tables in which 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. (AC 520)

many-to-many relationship (M:N)

A relationship between two tables in which each record in the first table matches many records in the second table, and each record in the second table matches many records in the first table. For many-to-many relationships, you create a third table and form one-to-many relationships between the two original primary tables and the new related table. (AC 516)

What is a self-join?

A self-join is a join between a table and itself.

relationship table

A table created for the sole purpose of specifying a many-to-many relationship between two other tables. For many-to-many relationships, you form one-to-many relationships between the two original primary tables and the relationship table. (AC 517)

History table

A table that contains data that is no longer needed for current processing but that you might need to reference in the future. (AC 500)

Entity sub-type

A table whose primary key is a foreign key to a second table and whose fields are additional fields for the second table. (AC 520)

Append query

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

update query

An action query that changes selected field values from selected records in one or more tables based on the criteria you specify. (AC 499)

Delete query

An action query that deletes a group of records matching the criteria you specify from one or more tables. (AC 499)

What is an entity sub-type?

An entity subtype is a table whose primary key is a foreign key to a second table and whose fields are additional fields for the second table.

What is an index?

An index is a list that relates field values to the records that contain those field values.

What is the difference between an inner join and an outer join?

An inner join selects records from two tables when they have matching values in the common field(s). An outer join selects all records from one table and records from a second table whose common field value(s) match records in the first table.

self-join

An inner or outer join between a table and itself. (AC 529)

What does an update query do?

An update query changes selected field values from selected records in one or more tables based on a condition.

The number of occurrences of an expression is determined using the ___ function in a form or report

COUNT

A form created from related tables usually consists of a ___ table which is the "one" side of the one-to-many relationship with a subform

Primary

How does the design grid change when you create an update query?

The Update To row replaces the Show and Sort rows in the design grid.

What precations should you take before running an action query?

You should preview the results before running an action query to confirm that the correct records are selected. You do this by creating a select query version of the query.

make-table

query An action query that creates a new table by copying selected fields in records from one or more existing tables. (AC 498)

In Access, an index is generated automatically for a table's______Key?

a. The primary key for the tblDepartment table is DepartmentID, and the primary key for the tblEmployee table is EmployeeSSN. b. There is a one-to-many relationship between the primary tblDepartment table and the related tblEmployee table. c. Yes, an inner join is possible based on the common field of DepartmentID. One example of an inner join is a list of all employees, including the EmployeeName, EmployeeSSN, and DepartmentName fields, in alphabetical order by EmployeeName. d. Yes, an outer join is possible. One example of an outer join is a list that shows all records from the tblDepartment table and their employees, even those departments without any employees currently assigned.

What are the three types of relationships you can define between tables?

one-to-many (1:M), many-to-many (M:N), one-to-one (1:1)