[Year 12 IT Apps] Qu A 15

[Maggie Iaquinto]

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