[Year 12 IT Apps] Qu A 15

Geoff Moss geoffmoss37 at optusnet.com.au
Wed Nov 14 20:06:53 EST 2007 

WARNING: This e-mail has been altered by MIMEDefang.  Following this
paragraph are indications of the actual changes made.  For more
information about your site's MIMEDefang policy, contact
Mail Administrator <postmaster at edulists.com.au>.  For more information about MIMEDefang, see:

            http://www.roaringpenguin.com/mimedefang/enduser.php3

An attachment named db1.mdb was removed from this document as it
constituted a security hazard.  If you require this document, please contact
the sender and arrange an alternate means of receiving it.

-------------- next part --------------
Hi Litsa

I set the input mask.

I have attached a sample database "db1.mdb"  and provided for a set prefix 
of "(03)" and also enabled a variable prefix with "(0"9")".

The quotes used are for the input mask.

I was surprised Access allowed this and only discovered it today.  LIke you, 
I did not expect it to work, but it did.  One of the benefits of discussions 
we have had today.

As stated earlier, I cannot vouch the same will apply for other database 
management systems.

Regards

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 7:21 PM
Subject: Re: [Year 12 IT Apps] Qu A 15


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

More information about the itapps mailing list