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

[Timmer-Arends]

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/20110404/8c6758bb/attachment.html