Refining Queries  «Prev 

MS Access Query join types - Quiz

Query join types, query types, and action queries

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which type of join would be used if you wanted to make sure only clients (Table 1) were displayed that had a project (Table 2) assigned to them?
Please select the best answer.
  A. Left outer join
  B. Inner join
  C. Right outer join
  D. Middle outer join

2. Which type of query would you use to add new records to an existing table?
Please select the best answer.
  A. Make Table
  B. Delete
  C. Update
  D. Append

3. Which action query does not destroy or alter existing information?
Please select the best answer.
  A. Make Table queries
  B. Delete queries
  C. Append queries
  D. Update queries
Correct answers:

Your Score: 0