Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Database Management Concepts

Database Management Concepts

Compound Conditions, Computed Fields, Using Special Operators

Bleu (Jia-Huei Ren)

March 16, 2015
Tweet

More Decks by Bleu (Jia-Huei Ren)

Other Decks in Education

Transcript

  1. Database Management Concepts 49941131 Jia-Huei, Ren

  2. Topic • Compound Conditions • Computed Fields • Using Special

    Operators
  3. Topic • Compound Conditions • Computed Fields • Using Special

    Operators
  4. Topic • Compound Conditions • Computed Fields • Using Special

    Operators
  5. Compound Conditions 5

  6. AND vs. OR

  7. NOT Reverses the truth or falsity of the original condition

  8. BETWEEN Value must be between the listed numbers

  9. Compound Conditions (continued) FIGURE 3-16: Query results FIGURE 3-15: Compound

    condition that uses the AND operator 9
  10. Compound Conditions (continued) FIGURE 3-18: Query results FIGURE 3-17: Compound

    condition that uses the OR operator 10
  11. Computed Fields Computed field or calculated field Field whose values

    you derive from existing fields Can involve: Addition (+) Subtraction (-) Multiplication (*) Division (/) 11
  12. Computed Fields (continued) FIGURE 3-26: Query results FIGURE 3-25: SQL

    query with a computed field and condition 12
  13. Using Special Operators

  14. Wildcards in Access SQL

  15. Asterisk : * any collection of characters

  16. Question mark : ? any individual character

  17. Wildcards in Access SQL

  18. Same?

  19. Same?

  20. Percent sign : % any collection of characters

  21. Underscore : _ any individual character

  22. To use a wildcard, include the LIKE operator in the

    WHERE clause
  23. IN operator provides a concise way of phrasing certain conditions

  24. Using Special Operators (LIKE and IN) (continued) FIGURE 3-28: Query

    results FIGURE 3-27: SQL query with a LIKE operator 24
  25. Using Special Operators (LIKE and IN) (continued) FIGURE 3-30: Query

    results FIGURE 3-29: SQL query with an IN operator 25
  26. Thanks