MrSchmid.com

Quick quiz review - creating a critera for queries

Posted On: Wed, 2008-01-16 23:01 by mrschmid

Remember, this quiz is a little different in that it's a exercise that you'll need to complete. Here's a couple helpful hints:
- know your relational operators (> greater than. < less than. <= less than or equal to. >= greater than or equal to. <> not equal to. )
- know your wildcards (* will match anything while ? Only matches one character) Example: starts in "s" would be s* or ends in "ing" would be "*ing"
- know how to turn a range of dates into a relational operator critera. Example: between 1/1/08 and 1/31/08 would be >=1/1/08 AND <=1/31/08
- its very logical, so remember what you've been doing in class, use your head and I know you'll do great!

( categories: )

Poll