This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Create relationships: 1)click and drag corrosponding things Database datatypes= associate feilds ex) groups; yes no filtering= just liek a query but dont restrict on fields; restrict on rows boolean operators= and, or, or not function of wildcards in queries=* pretty much type in a word and it uses all uses of word Change a datatype: 1)right click 2)design view 3)change datatype to corrospond to w.e category 4)text if description really long change to memo Filters: 1)double click * 2)if wanna restrict- double click one in box and uncheck Boolean Op: 1)click two things 2)"or" increases results ex) <1990 Or >1999 3)write in criteria section 4)"Not" exludes things. <> "words" 5)LIKE= uses wildcard and * ex)"old*" - old and then anything after ex)"*Old" - cold and mold ex)"*old*" > greater than...
View Full Document
This note was uploaded on 12/14/2011 for the course CSE 101 taught by Professor Allusethis during the Fall '08 term at Michigan State University.
- Fall '08