<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19019">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Come on!</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Yes/No, True/false - They are both
Boolean</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>But where were we? Oh yes that question 3a in
the sample exam - there is no field <FONT color=#221e1f><FONT color=#221e1f>that
has Boolean data type.</FONT></FONT></FONT></FONT></DIV>
<DIV><FONT color=#221e1f size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#221e1f size=2 face=Arial>Robert Hind (Semi-retired) OOF,
GOM<BR>Ashwood and Traralgon<BR><A
href="mailto:robert@yinnar.com">robert@yinnar.com</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#221e1f size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=kel@mckinnonsc.vic.edu.au
href="mailto:kel@mckinnonsc.vic.edu.au">Mark KELLY</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, April 04, 2011 6:33
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] The sample
ITA questions -- Number 3 inSection B</DIV>
<DIV><BR></DIV>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).
<BR>Which RDBMS <B>does</B> have a fair dinkum native Boolean
datatype?<BR><BR>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.<BR><BR>
<DIV class=gmail_quote>On 4 April 2011 18:16, Timmer-Arends <SPAN
dir=ltr><<A
href="mailto:timmer@melbpc.org.au">timmer@melbpc.org.au</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV bgcolor="#ffffff">
<DIV><FONT size=2 face=Arial>Hello Maggie</FONT></DIV>
<DIV class=im>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV>2. Microslop Access does not have a Boolean datatype. It uses Yes/No as
the closest thing to that. </DIV>
<DIV> </DIV></DIV>
<DIV><FONT size=2 face=Arial>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. </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>For example, you can use a "yes/no" field as a
condition in a calculated field in a query. <BR> </FONT><FONT
size=2 face=Arial>moreJunk: IIf([junk],"hello","goodbye")</FONT></DIV>
<DIV><FONT size=2 face=Arial>where [junk] is a field declared as yes/no; ie
it's boolean</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Regards</FONT></DIV>
<DIV><FONT size=2 face=Arial>Robert T-A</FONT></DIV>
<DIV><FONT size=2 face=Arial>Brighton
SC</FONT></DIV></DIV><BR>_______________________________________________<BR><A
href="http://www.edulists.com.au"
target=_blank>http://www.edulists.com.au</A> - FAQ, resources, subscribe,
unsubscribe<BR>IT Applications Mailing List kindly supported by<BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"
target=_blank>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>
- Victorian Curriculum and Assessment Authority and<BR><A
href="http://www.vitta.org.au" target=_blank>http://www.vitta.org.au</A>
- VITTA Victorian Information Technology Teachers Association
Inc<BR></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>Mark Kelly<BR>Manager
of ICT, Reporting, IT Learning Area<BR>McKinnon Secondary College<BR>McKinnon
Rd McKinnon 3204, Victoria, Australia<BR>Direct line / Voicemail: +613 8520
9085, Fax +613 9578 9253<BR><A href="mailto:kel@mckinnonsc.vic.edu.au"
target=_blank>kel@mckinnonsc.vic.edu.au</A><BR>VCE IT Lecture Notes: <A
href="http://vceit.com" target=_blank>http://vceit.com</A><BR>Moderator: IT
Applications Edulist<BR><BR><FONT size=+0>All generalisations are false,
except this one.</FONT><BR><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.edulists.com.au
- FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List
kindly supported
by<BR>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority
and<BR>http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc</BLOCKQUOTE></BODY></HTML>