[Year 12 IT Apps] Qu A 15

[Litsa Tzelepis]

i agree - if you define a field as a number, it won't accept the brackets.

----- Original Message ----- 
From: "Maggie Iaquinto" <IAQUIM at bialik.vic.edu.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Wednesday, November 14, 2007 12:47 PM
Subject: RE: [Year 12 IT Apps] Qu A 15


> When there are soft brackets and spaces, it must be text since text is
> alphanumeric.
>
> Why no numbers for postcodes? 4 chars, limited range, all number.
>
> -----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
>
>
>
>
>
> _______________________________________________
> 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
>