RelationalDB
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Creating Queries
«Prev
Next»
Data Manipulation
Finding Sorting Filtering Data
Finding Data Table
Sorting Access Records
Sorting Access Records
Filter Records to Display Subset
Display Record Subset
Filter Records Multiple Criteria
Filter Records Complex Criteria
Advanced Filter Uses
Single Table Access Conclusion
Creating Access Queries
What are Queries
Query Access Database Window
Simple Query Wizard
Query Design View
Creating Query Design View
Save Query Design
Editing Query Design
Adding Criteria to Queries
Values in Criteria Expressions
Multiple Queries in Access
Specifying Sort Order
Creating Calculated Fields
Creating Access Forms
Access Form
Access Auto Form
Displaying Records Access Form
Edit Access Database
Create Access Forms
Form Design View
Save Access Form
Access Resize Controls
Access Form controls
Add Access Bound Controls
Toolbox Buttons Add Controls
Format form Controls Design form
Create Calculated Controls
Design Create Report
MS Access Reports
Navigating Report View
Access Mailing Labels
Report Design View
Header Footer Sections
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.
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