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

[Robert Hind]

Come on!

Yes/No, True/false - They are both Boolean

But where were we? Oh yes that question 3a in the sample exam - there is no field that has Boolean data type.

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




.

  ----- Original Message ----- 
  From: Mark KELLY 
  To: Year 12 IT Applications Teachers' Mailing List 
  Sent: Monday, April 04, 2011 6:33 PM
  Subject: Re: [Year 12 IT Apps] The sample ITA questions -- Number 3 inSection B


  So Access doesn't have a true Boolean datatype.... and neither does Filemaker (one uses a number field with values of non-zero or 0). 
  Which RDBMS does have a fair dinkum native Boolean datatype?

  Maybe we're being led down a digital garden path!  It might turn out that there is no RDBMS with a true Boolean datatype, which I'm afraid would lead to a rather stern letter to The Times.


  On 4 April 2011 18:16, Timmer-Arends <timmer at melbpc.org.au> wrote:

    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




  -- 
  Mark Kelly
  Manager of ICT, Reporting, IT Learning Area
  McKinnon Secondary College
  McKinnon Rd McKinnon 3204, Victoria, Australia
  Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
  kel at mckinnonsc.vic.edu.au
  VCE IT Lecture Notes: http://vceit.com
  Moderator: IT Applications Edulist

  All generalisations are false, except this one.




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


  _______________________________________________
  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/20110404/9e64dd44/attachment.html