<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'>Mark<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'>The article refers to Access 2003 and is copyright dated 2003<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'>10 years out of date.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D;mso-fareast-language:EN-US'>J</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'>Mark (the other one)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'>Luther College<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><P>
<TABLE style="WIDTH: 400px" cellSpacing=0 cellPadding=0 background=""
border=0><TBODY>
<TR>
<TD><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #184689; PADDING-TOP: 5px; FONT-FAMILY: arial">Mark Scott </SPAN>
<SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10px; COLOR: #184689; PADDING-TOP: 5px; FONT-FAMILY: arial"><BR></SPAN>
<SPAN style="MARGIN-TOP: 0px; FONT-SIZE: 12px; COLOR: #184689; FONT-FAMILY: arial">Daily Administrator<BR></SPAN>
<SPAN style="MARGIN-TOP: 0px; FONT-SIZE: 7px; COLOR: #FFFFFF; FONT-FAMILY: arial">Luther<BR></SPAN>
<DIV
style="FONT-SIZE: 12px; COLOR: #808285; PADDING-TOP: 15px; FONT-FAMILY: arial">Plymouth
Road<BR>Croydon Hills Victoria 3136<BR>
<BR></DIV>
<SPAN style="MARGIN-TOP: 0px; FONT-SIZE: 7px; COLOR: #FFFFFF; FONT-FAMILY: arial">Luther<BR></SPAN>
<DIV
style="FONT-SIZE: 12px; COLOR: #808285; PADDING-TOP: 5px; FONT-FAMILY: arial"><SPAN>Telephone
(03) 9724 2000<BR>Direct Line</SPAN> (03) 9724 2023
<DIV style="COLOR: #808285; PADDING-TOP: 5px">
<A style="COLOR: #808285; TEXT-DECORATION: none" href="http://www.luther.vic.edu.au/"><FONT face=Arial
size=2>www.luther.vic.edu.au</FONT></A>
<DIV style="FONT-SIZE: 9px; COLOR: #808285; PADDING-TOP: 5px"></DIV>
</DIV></DIV></TD>
<TD><A href="http://www.luther.vic.edu.au/"><FONT face=Arial><IMG
id=luther title="Luther College" style="WIDTH: 143px; HEIGHT: 143px"
height=143 alt="Luther College" hspace=0
src="cid:luther_college_email5eb677"
width=143 align=textTop border=0 name=luther
college></FONT></A></TD></TR></TBODY></TABLE></P>
<P></P>
<DIV style="CLEAR: both; MARGIN-TOP: 10px; FLOAT: left; WIDTH: 100%"><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 9px; COLOR: #ca003a; LINE-HEIGHT: 110%; FONT-FAMILY: arial">Please
consider the environment before printing this email.<BR></SPAN>
<P
style="MARGIN-TOP: 5px; FONT-SIZE: 9px; COLOR: #808285; LINE-HEIGHT: 110%; FONT-FAMILY: arial">This
email and any attachments may contain privileged and confidential information.
<BR>If you are not the intended recipient you may not distribute or reproduce
this email <BR>or attachments. If you have received this message in error please
notify us by return mail.</P></DIV><BR style="CLEAR: both">
<DIV></DIV><br><p class=MsoNormal><b><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Mark<br><b>Sent:</b> Tuesday, 4 June 2013 11:24 AM<br><b>To:</b> Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12 IT Apps] Data type for postcode<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Before this thread is bought by Disney and turned into a blockbuster family entertainment feature, here is what Microsoft offers about working with postcodes/ZIP codes in Access...<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="http://office.microsoft.com/en-au/access-help/working-with-postal-codes-in-access-HA001034544.aspx">http://office.microsoft.com/en-au/access-help/working-with-postal-codes-in-access-HA001034544.aspx</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On 3 June 2013 14:20, Andrew Shortell <<a href="mailto:shortell@get2me.net" target="_blank">shortell@get2me.net</a>> wrote:<o:p></o:p></p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal>also in USA there are ZIP codes that begin with two leading zeros <o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Quote: <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>many of the lowest ZIP codes, which begin with '0', are in the </span><a href="http://en.wikipedia.org/wiki/New_England" target="_blank" title="New England"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>New England</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> region. Also in the '0' region are </span><a href="http://en.wikipedia.org/wiki/New_Jersey" target="_blank" title="New Jersey"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>New Jersey</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> (non-contiguous with the remainder of the '0' area), </span><a href="http://en.wikipedia.org/wiki/Puerto_Rico" target="_blank" title="Puerto Rico"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>Puerto Rico</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>, the </span><a href="http://en.wikipedia.org/wiki/US_Virgin_Islands" target="_blank" title="US Virgin Islands"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>US Virgin Islands</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> and </span><a href="http://en.wikipedia.org/wiki/APO/FPO" target="_blank" title="APO/FPO"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>APO/FPO</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> military addresses for personnel stationed in </span><a href="http://en.wikipedia.org/wiki/Europe" target="_blank" title=Europe><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>Europe</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>, </span><a href="http://en.wikipedia.org/wiki/Africa" target="_blank" title=Africa><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>Africa</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>, </span><a href="http://en.wikipedia.org/wiki/Southwest_Asia" target="_blank" title="Southwest Asia"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>Southwest Asia</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> and aboard vessels based in the waters adjoining those lands; APO/FPO addresses are also used by U.S. diplomatic and consulary facilities. The lowest ZIP code is in </span><a href="http://en.wikipedia.org/wiki/Holtsville,_New_York" target="_blank" title="Holtsville, New York"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>Holtsville, New York</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> (00501, a ZIP code exclusively for the </span><a href="http://en.wikipedia.org/wiki/U.S._Internal_Revenue_Service" target="_blank" title="U.S. Internal Revenue Service"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#0B0080;text-decoration:none'>U.S. Internal Revenue Service</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> center there). </span><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>source <a href="http://en.wikipedia.org/wiki/Zip_Codes" target="_blank">http://en.wikipedia.org/wiki/Zip_Codes</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Also they too have postcodes/zip codes that cross state boundaries for post office convenience<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>This has certainly become esoteric and thus fascinating!<o:p></o:p></p></div><div><p class=MsoNormal>Andrew <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><div><div><div><div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'>Andrew Shortell<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'>Educator<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'>CRC Melton<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'><a href="mailto:shortell@get2me.net" target="_blank">shortell@get2me.net</a> (This List)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'>@acsbear8 (twitter)<o:p></o:p></span></p></div></div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'><a href="http://www.vitta.org.au/" target="_blank">VITTA</a> CoM Member<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'><o:p> </o:p></span></p></div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif"'><o:p> </o:p></span></p></div></div></div></div></blockquote></div><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal><snip><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>--<o:p></o:p></p><div><p class=MsoNormal>Mark Kelly<o:p></o:p></p></div><div><p class=MsoNormal>mark AT vceit DOT com<o:p></o:p></p></div><div><p class=MsoNormal><a href="http://vceit.com" target="_blank">http://vceit.com</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></body></html>