<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial>Now we have to add "claculations" to "refleact" as
items that passed through a data validation system. So validation does not
ensure that inaccurate data gets into a system, it only tries to do
so.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Wingdings size=7><STRONG>J</STRONG></FONT></DIV>
<DIV><FONT face=Arial>Robert Hind (Semi-retired)<BR>Ex Traralgon and
Ashwood<BR></FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>----- Original Message ----- </FONT></DIV>
<DIV><FONT face=Arial>From: "Mark Scott" <</FONT><A
href="mailto:msc@luther.vic.edu.au"><FONT
face=Arial>msc@luther.vic.edu.au</FONT></A><FONT face=Arial>></FONT></DIV>
<DIV><FONT face=Arial>To: "Year 12 IT Applications Teachers' Mailing List"
<</FONT><A href="mailto:itapps@edulists.com.au"><FONT
face=Arial>itapps@edulists.com.au</FONT></A><FONT face=Arial>></FONT></DIV>
<DIV><FONT face=Arial>Sent: Wednesday, November 14, 2007 1:06 PM</FONT></DIV>
<DIV><FONT face=Arial>Subject: RE: [Year 12 IT Apps] Qu A 15</FONT></DIV>
<DIV><FONT face=Arial><BR></FONT></DIV><BR><FONT face=Arial>It prevents them
being used as a number in claculations etc. <BR><BR><BR>Mark Scott<BR>Luther
college <BR><BR>-----Original Message-----<BR>From: </FONT><A
href="mailto:itapps-bounces@edulists.com.au"><FONT
face=Arial>itapps-bounces@edulists.com.au</FONT></A><BR><FONT
face=Arial>[mailto:itapps-bounces@edulists.com.au] On Behalf Of Maggie
Iaquinto<BR>Sent: Wednesday, 14 November 2007 12:47 PM<BR>To: Year 12 IT
Applications Teachers' Mailing List<BR>Subject: RE: [Year 12 IT Apps] Qu A
15<BR><BR>When there are soft brackets and spaces, it must be text since text
is<BR>alphanumeric. <BR><BR>Why no numbers for postcodes? 4 chars, limited
range, all number.<BR><BR>-----Original Message-----<BR>From: </FONT><A
href="mailto:itapps-bounces@edulists.com.au"><FONT
face=Arial>itapps-bounces@edulists.com.au</FONT></A><BR><FONT
face=Arial>[mailto:itapps-bounces@edulists.com.au] On Behalf Of Keith
Richardson<BR>Sent: Wednesday, 14 November 2007 12:41 PM<BR>To: List
ITA<BR>Subject: [Year 12 IT Apps] Qu A 15<BR><BR>I have a beef about this
topic.<BR>Some years ago I attended an advanced Access three day course to get
my<BR>head around this database program.<BR>We were told in no uncertain way,
that one should NOT use number as a<BR>data type for phone numbers or postcodes
etc. In fact it should only be<BR>used when you intend doing mathematical
calculations with it's contained<BR>data further down the track.<BR>Therefore, I
choose A for Qu 15 (Part A), but in doing so remember one<BR>or more of the
VITTA practice ITA exams that indicated it should be<BR>number.<BR>What do
others think?<BR>Keith<BR>Keith Richardson<BR>ITA List Moderator<BR>Head of ICT,
Leibler Yavneh College<BR>Elsternwick<BR>Ph: 03.9528.4911<BR></FONT><A
href="mailto:k.richardson@yavneh.vic.edu.au"><FONT
face=Arial>k.richardson@yavneh.vic.edu.au</FONT></A><BR><BR><FONT
face=Arial>_______________________________________________<BR></FONT><A
href="http://www.edulists.com.au"><FONT
face=Arial>http://www.edulists.com.au</FONT></A><FONT face=Arial> - FAQ,
resources, subscribe, unsubscribe IT<BR>Applications Mailing List kindly
supported by<BR></FONT><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><FONT
face=Arial>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</FONT></A><FONT
face=Arial> -<BR>Victorian Curriculum and Assessment Authority and<BR></FONT><A
href="http://www.vitta.org.au"><FONT
face=Arial>http://www.vitta.org.au</FONT></A><FONT face=Arial> - VITTA
Victorian Information Technology<BR>Teachers Association
Inc<BR><BR><BR><BR><BR><BR>_______________________________________________<BR></FONT><A
href="http://www.edulists.com.au"><FONT
face=Arial>http://www.edulists.com.au</FONT></A><FONT face=Arial> - FAQ,
resources, subscribe, unsubscribe IT<BR>Applications Mailing List kindly
supported by<BR></FONT><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><FONT
face=Arial>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</FONT></A><FONT
face=Arial> -<BR>Victorian Curriculum and Assessment Authority and<BR></FONT><A
href="http://www.vitta.org.au"><FONT
face=Arial>http://www.vitta.org.au</FONT></A><FONT face=Arial> - VITTA
Victorian Information Technology<BR>Teachers Association
Inc<BR><BR>_______________________________________________<BR></FONT><A
href="http://www.edulists.com.au"><FONT
face=Arial>http://www.edulists.com.au</FONT></A><FONT face=Arial> - FAQ,
resources, subscribe, unsubscribe<BR>IT Applications Mailing List kindly
supported by<BR></FONT><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><FONT
face=Arial>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</FONT></A><FONT
face=Arial> - Victorian Curriculum and Assessment Authority and<BR></FONT><A
href="http://www.vitta.org.au"><FONT
face=Arial>http://www.vitta.org.au</FONT></A><FONT face=Arial> - VITTA
Victorian Information Technology Teachers Association
Inc<BR><BR></FONT></BODY></HTML>