<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"><base href="x-msg://190/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">hi Damien<div><br></div><div>I have moved to stressing that databases get rid of duplicate data -- leads me nicely into normalisation -- and thus any item of data only needs to be changed in a single spot</div><div><br></div><div>I never talk about saving space nowadays - or reducing processing given the speed of modern equipment </div><div><br></div><div>so best practice is reducing duplication,</div><div><br></div><div>creating a query just to get a calculated field ... is that not "duplication" of effort? thus in efficient ?? ( *grin )</div><div><br></div><div>Andrew</div><div><br><div apple-content-edited="true">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Andrew Shortell</div><div>Educator</div><div>CRC Melton</div><div><br></div><div><br></div><div><a href="mailto:shortell@get2me.net">shortell@get2me.net</a> (This List)</div><div>@acsbear8 (twitter)</div></div></span><a href="http://www.vitta.org.au/">VITTA</a> CoM Member</div></span><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br><div><div>On 13/02/2014, at 1:38 PM, "ATKINSON-BUCK, Damien" <<a href="mailto:Damien.ATKINSON-BUCK@ivanhoe.com.au">Damien.ATKINSON-BUCK@ivanhoe.com.au</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-AU" link="blue" vlink="purple" style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div class="WordSection1" style="page: WordSection1; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">Hi folks,<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; "> Just looking into Outcome 2 and looking at the 2010 version of MS Access. I hadn’t noticed before, but you can now create a calculated field in the table definitions. This means that not only does it do the calculation (duh) but stores that value too, so you no longer have to create a query to do that.<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">Now, I always stress to my cherubs that one of the primary reasons for making a database is to reduce the amount of space the data is going to take up. This new ‘feature’ does the reverse. Given hard drives are so cheap and our down databases are comparatively quite small, it doesn’t really affect SAC scenarios……… but should we be teaching best practices or “The Way of the Access”? How do others feel about this?<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">Cheers<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 10pt; font-family: Arial, sans-serif; ">Damien<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 9pt; font-family: 'Times New Roman', serif; color: rgb(136, 2, 49); "><br></span></b><b><span style="font-size: 12pt; font-family: Arial, sans-serif; color: rgb(130, 0, 44); ">Damien</span></b><b><span style="font-size: 9pt; font-family: 'Times New Roman', serif; color: rgb(136, 2, 49); "> </span></b><b><span style="font-size: 12pt; font-family: Arial, sans-serif; color: rgb(136, 2, 49); ">Atkinson-Buck</span></b><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><br></span><span style="font-size: 10pt; font-family: Arial, sans-serif; ">Head of Learning Area: Technology/Arts</span><span style="font-size: 8pt; font-family: 'Times New Roman', serif; "><o:p></o:p></span></div><table class="MsoNormalTable" border="0" cellpadding="0"><tbody><tr><td style="padding: 0.75pt 36pt 0.75pt 0.75pt; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 8pt; font-family: Arial, sans-serif; ">p:</span></b><span style="font-size: 8pt; font-family: Arial, sans-serif; "><span class="Apple-converted-space"> </span>+61 3 9490 3848</span><span style="font-size: 8pt; font-family: Arial, sans-serif; "><o:p></o:p></span></div></td><td style="padding: 0.75pt 36pt 0.75pt 0.75pt; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 8pt; font-family: Arial, sans-serif; ">e:</span></b><span style="font-size: 8pt; font-family: Arial, sans-serif; "><span class="Apple-converted-space"> </span><a href="mailto:damien.atkinson-buck@ivanhoe.com.au" style="color: purple; text-decoration: underline; "><span style="color: blue; ">damien.atkinson-buck@ivanhoe.com.au</span></a></span><span style="font-size: 8pt; font-family: Arial, sans-serif; "><o:p></o:p></span></div></td></tr><tr><td style="padding: 0.75pt; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 8pt; font-family: Arial, sans-serif; ">f:</span></b><span style="font-size: 8pt; font-family: Arial, sans-serif; "><span class="Apple-converted-space"> </span>+61 3 9490 3490</span><span style="font-size: 8pt; font-family: Arial, sans-serif; "><o:p></o:p></span></div></td><td style="padding: 0.75pt; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 8pt; font-family: Arial, sans-serif; ">w:</span></b><span style="font-size: 8pt; font-family: Arial, sans-serif; "> </span><span style="font-size: 8pt; font-family: Arial, sans-serif; "><a href="http://www.ivanhoe.com.au" style="color: purple; text-decoration: underline; "><span style="">www.ivanhoe.com.au</span></a><o:p></o:p></span></div></td></tr></tbody></table><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><image001.jpg></span><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><br></span><span style="font-size: 7.5pt; font-family: Arial, sans-serif; ">Please consider the environment before printing this e-mail.</span><o:p></o:p></div></div><br><br><br><br>Privacy, Virus and Copyright Warning<br><br>The information contained in this electronic message (e-mail), and any files transmitted with it:<br><br>* is intended for the named recipients only. If you have received this in error, please advise the sender and delete it and any copies immediately;<br>* Any personal information in this email must be used in accordance with the Privacy Act 1988 and this always applies even if it has been sent to you in error.<br>* represents the views of the sender and does not necessarily represent the views or formal advice of Ivanhoe Grammar School;<br>* may be subject to Copyright, so no further use should be made of it without the author's permission.<br><br>The School does not represent or warrant that the email or any files attached do not contain errors or are free from computer viruses or other defects nor does it accept responsibility for any loss or damage resulting directly or indirectly from the use of the email or any attached files. _______________________________________________<br><a href="http://www.edulists.com.au" style="color: purple; text-decoration: underline; ">http://www.edulists.com.au</a><span class="Apple-converted-space"> </span>- FAQ, resources, subscribe, unsubscribe<br>IT Applications Mailing List kindly supported by<br><a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" style="color: purple; text-decoration: underline; ">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a><span class="Apple-converted-space"> </span>- Victorian Curriculum and Assessment Authority <br><br><a href="http://www.vitta.org.au" style="color: purple; text-decoration: underline; ">http://www.vitta.org.au</a><span class="Apple-converted-space"> </span> - VITTA Victorian Information Technology Teachers Association Inc <br><br><a href="http://www.swinburne.edu.au/ict/schools" style="color: purple; text-decoration: underline; ">http://www.swinburne.edu.au/ict/schools</a><span class="Apple-converted-space"> </span>- Swinburne University</div></blockquote></div><br></div></body></html>