[Year 12 IT Apps] Qu A 15

[Litsa Tzelepis]

hi geoff, now i'm intrigued.

i tried entering in the phone number into my number field and it still 
doesn't accept it - with or without brackets.
how did you type it in? "(03)" 9876 6543 or "("03")" 9876 6543?

also, why would you go to the trouble of using quotes to enter data? 
shouldn't data entry be relatively complex-free?

litsa

----- Original Message ----- 
From: "Geoff Moss" <geoffmoss37 at optusnet.com.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Wednesday, November 14, 2007 6:19 PM
Subject: Re: [Year 12 IT Apps] Qu A 15


> Hi Litsa
>
> Litsa said: "if you define a field as a number, it won't accept the 
> brackets"
>
> I was interested in this and actually tested it today on Access and when I 
> placed the brackets in quotation marks it was accepted in the field with 
> number data type, as with a field with text data type when using an input 
> mask with the brackets included.
>
> As stated earlier by Mark, zeros as prefix numbers will not appear and 
> there are difficulties with ext. numbers and some other number 
> configurations. Also, we would not use phone numbers in calculations so 
> there is no need for them toof number type.
>
> I cannot speak for other databases, other than Access.
>
> Cheers
> Geoff Moss
> RMIT
>
>
> ----- Original Message ----- 
> From: "Litsa Tzelepis" <htzelepis at msj.melb.catholic.edu.au>
> To: "Year 12 IT Applications Teachers' Mailing List" 
> <itapps at edulists.com.au>
> Sent: Wednesday, November 14, 2007 4:23 PM
> Subject: Re: [Year 12 IT Apps] Qu A 15
>
>
>>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
>>>
>>
>> _______________________________________________
>> 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
>>
>>
>> -- 
>> No virus found in this incoming message.
>> Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 
>> 269.15.31/1128 - Release Date: 13/11/2007 11:09 AM
>>
>>
>
> _______________________________________________
> 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
>