Access Criteria Examples

1. Access Criteria Examples Dr. Lloyd D. Brooks Professor of Management Information Systems

2. Criteria • Criteria are entered on the criteria Row on the Query Form. • Field Name • Table Name • Show • Criteria • Click the ! Icon to run the query

3. Query Examples • 300 • =475.28 • <200 • >500 • >=700 • <=750 • Not 700

4. Query Examples • #12/23/00# • >#8/15/00# • #7/23/00#+60 • #9/19/00#-#8/3/99# • Now()

5. Criteria Examples • Sale Date a field in the table • NOW() - [Sale Date] on the field row • >60 on the criteria row • Note: This criteria will determine the customers whose account is more than 60 days overview.

6. Criteria Examples • Salary a field in the table • [Salary] * 1.05 on the field row • Note: This computation will determine the new salary after granting a 5% raise.

7. Criteria Examples • “TN” • “Johnson” • IN(“TN”,”AR”,”MS”) • Between #8/14/98# and #9/19/00# • “TR788”

8. Compound Criteria • And place criteria on the same row • Or place criteria on different rows

9. Sorting • Ascending • Descending • No sort • Major field Must appear on the left • Minor field Must appear on the right

10. Entering a Label With a Computation • [Purchase] + [Sales Tax] • Note: This will provide an expression notation with the answer • Total:[Purchase] + [Sales Tax] • Note: This will provide the word “Total” with the answer.

11. Criteria Examples • “C*” • “*tion” • “*ville” • “T?m” • “T??e” • “T?l?”

12. Questons?