[Year 12 IT Apps] Qu A 15

[Geoff Moss]

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
>
>