[Year 12 IT Apps] Qu A 15

[Trish Cotter]

It is in fact handy to have a postcode as a number. Why? Because you are then able to do a range
validation Eg. Between or > or < etc.
Phone numbers are text. Answer is still A.
-- 
Regards,
Trish Cotter
Koonung Secondary College
*******
tcotter at koonung.vic.edu.au

On Wed, November 14, 2007 1:45 pm, Mark Scott wrote:
>
> It is interestinmg that a valuable learning opportunity came from
> soneone's inability to validate properly.
>
> Mark Scott
>
> -----Original Message-----
> From: itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of DANIELA LUPONE
> Sent: Wednesday, 14 November 2007 1:24 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: RE: [Year 12 IT Apps] Qu A 15
>
> I had the same problem (and discussed this with my kids prior to the
> exam) with this question. I believe in this case the answer can only be
> A as there are brackets but even if there were no brackets I would
> choose A for a telephone or postcode field as no calculations need to be
> performed on these fields.
>
> Daniela Lupone
> StColumba's College, Essendon
>
> -----Original Message-----
> From: itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au]On Behalf Of Keith Richardson
> Sent: Wednesday, 14 November 2007 12:41 PM
> To: List ITA
> Subject: [Year 12 IT Apps] Qu A 15
>
>
> I have a beef about this topic.
> Some years ago I attended an advanced Access three day course to get my
> head around this database program.
> We were told in no uncertain way, that one should NOT use number as a
> data type for phone numbers or postcodes etc. In fact it should only be
> used when you intend doing mathematical calculations with it's contained
> data further down the track.
> Therefore, I choose A for Qu 15 (Part A), but in doing so remember one
> or more of the VITTA practice ITA exams that indicated it should be
> number.
> What do others think?
> Keith
> Keith Richardson
> ITA List Moderator
> Head of ICT, Leibler Yavneh College
> Elsternwick
> Ph: 03.9528.4911
> k.richardson at yavneh.vic.edu.au
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IT
> Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
>
> ST COLUMBA'S COLLEGE LIMITED DISCLAIMER
>
> This E-mail and any attachments may be confidential and, if you are not
> the intended recipient, you must not disclose or use the information in
> this E-mail. If received in error, please notify us immediately and
> delete the E-mail and all copies. St Columba's College does not
> guarantee that this E-mail is virus or error free. The attached files
> are provided and may only be used on the basis that the user assumes all
> responsibility for any loss, damage or consequence resulting directly or
> indirectly from the use of the attached files, whether caused by the
> negligence of the sender or not. The content and opinions in this E-mail
> are not necessarily those of the college.
>
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IT
> Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - Victorian Curriculum and
> Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc
>