Creating Queries  «Prev  Next»

Matching Access Database Criteria - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1.
Record # Name Commission Date of Sale
1 Ronn $200 10/5/2019
2 Ronn $650 10/2/2019
3 Molinari $350 10/4/2019
4 Hudson $400 10/7/2019
5 Corey $600 10/11/2019
6 Corey $250 10/14/2019
7 Molinari $500 10/24/2019
8 Hudson $600 10/27/2019
9 Molinari $450 10/17/2019
10 Hudson $350 10/13/2019

Choose the record(s) that meet each criteria:
In the table above which records match the following criteria: Name=Hudson AND Date<10/10/99
Please select all the correct answers.
  A. 8
  B. 10
  C. 4
  D. 3

2. In the table above which records match the following criteria: Name= Corey OR Hudson AND Commision>$500
Please select all the correct answers.
  A. 4
  B. 5
  C. 8
  D. 6

3. In the table above which records match the following criteria: Commission<500 OR Date>10/10/99
Please select all the correct answers.
  A. 5
  B. 6
  C. 7
  D. 8
  E. 9
  F. 10

4. In the table above which records match the following criteria: Commission>500 AND Date>10/10/2019 Please select all the correct answers.
  A. 8
  B. 9
  C. 5
  D. 10

5. Use this design grid for the question below.
Which query design matches the above design grid?
Please select the best answer.
  A. Name=Hudson AND Date<10/10/2019
  B. Commission<500 OR Date>10/10/2019
  C. Commission>500 AND Date>10/10/2019
  D. Commission<500 AND Date<10/10/2019
  E. Name= Corey OR Hudson AND Commision>$500