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
• lt200
• gt500
• gt700
• lt750
• Not 700

4
Query Examples

• 12/23/00
• gt8/15/00
• 7/23/0060
• 9/19/00-8/3/99
• Now()

5
Criteria Examples

• Sale Date a field in the table
• NOW() - Sale Date on the field row
• gt60 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
• TotalPurchase 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?