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

[Matthew Williams]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110405/2babb594/attachment.html