Query This!
This is the type of query that adds, changes, or deletes multiple table records at a time.
What is an action query?
The three (3) types of relationships you define between tables.
What are one-to-many, many-to-many and one-to-one?
The is the type of query you would use to create a new table from one or more existing tables.
What is a make-table query?
The type of query that changes selected field values from selected records in one or more tables based on a condition.
What is an update query?
The type of join that selects records from two tables when they have matching values in the common field(s).
What is an inner join?
What you use when you want to find and return matching data and some dissimilar data from tables.
What is an outer join?
This object contains data that is no longer needed for current processing but that you might need to reference in the future.
What is a History Table?
Short hand for writing one-to-one, one-to-many and many-to-many relationships.
What are 1:1, 1:M and M:N?
DOUBLE JEOPARDY
This is the field for which an index is automatically generated.
What you would use when you want to add records from existing tables or queries to the end of another table.
What is an append query?
What we call a join that is between a table and itself.
What is a self-join?
DOUBLE JEOPARDY
These are the two reasons why you would not want to set up an index.