[Year 12 IT Apps] The sample ITA questions -- Number 3in Section B

[Robert Hind]

The question refers to "Boolean data type" not "Boolean operator" so should be true/false or yes/no in Access . No one of the data fields has such a data type.

Robert Hind (Semi-retired) OOF, GOM
Ashwood and Traralgon
robert at yinnar.com


  ----- Original Message ----- 
  From: Matthew Williams 
  To: Year 12 IT Applications Teachers' Mailing List 
  Sent: Tuesday, April 05, 2011 8:47 AM
  Subject: Re: [Year 12 IT Apps] The sample ITA questions -- Number 3in Section B


  Hi Rob

   

  I always thought Boolean operators were:

   

  NOT

   

  OR

   

  AND

   

  Thus in the sample paper M / F the Boolean operator would OR?

   

  Regards

   

  Matt

   

   

  From: Timmer-Arends [mailto:timmer at melbpc.org.au] 
  Sent: Monday, 4 April 2011 6:17 PM
  To: Year 12 IT Applications Teachers' Mailing List
  Subject: Re: [Year 12 IT Apps] The sample ITA questions -- Number 3 in Section B

   

  Hello Maggie

   

  2. Microslop Access does not have a Boolean datatype. It uses Yes/No as the closest thing to that. 

   

  in fact 'yes/no' in ms access is Boolean. MS just choose to display it as yes/no presumably in an effort to make it simpler for the average user. You can also choose to display it as true/false or on/off. 

   

  For example, you can use a "yes/no" field as a condition in a calculated field in a query. 
     moreJunk: IIf([junk],"hello","goodbye")

  where [junk] is a field declared as yes/no; ie it's boolean

   

   

  Regards

  Robert T-A

  Brighton SC



------------------------------------------------------------------------------


  _______________________________________________
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
  IT Applications Mailing List kindly supported by
  http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and
  http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110405/6a677445/attachment.html