<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 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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 bgcolor="white" lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">I think you’re right. Having calculated fields defined in the tables takes us right away from a pure Codd style database. On the other hand Filemaker and, on DOS, DataPerfect did it for years. Convenience over
purity?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">My gut feeling is to stay away from calculated fields at this stage and use queries. Always best to start with best practice and then learn the tricks.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Laurie Savage<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU"> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Groves, Brett G<br>
<b>Sent:</b> Wednesday, 26 March 2014 4:28 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] MS Access - Calculated fields<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi all – my 2 centimes<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Can’t really see the value of calculated fields in Access, maybe it is because I come at it from an SQL perspective but it represents fairly dodgy database practice methinks.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Can’t really see how you can have true 3N with a calculated field stored in a table? Or have I got my head around it wrong?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I don’t think I’ll be including it at present; students should be using forms (and attendant query) in datasheet view for such operations IMHO<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">Kind Regards,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">Brett Groves<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><img width="51" height="42" id="Picture_x0020_1" src="cid:image001.gif@01CF499C.F886BFA0" alt="logosmall"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">Melba College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">eLearning Leader<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">03 9725 8277 Ext 221<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><a href="http://melba.vic.edu.au/curriculum/elearning/">eLearning Resources for Educators</a> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><a href="http://melba.vic.edu.au/curriculum/elearning/elearning-newsletter/">Newsletter sign up</a> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><a href="http://us7.campaign-archive1.com/home/?u=3552e93cf6fe9d34510f19694&id=1cc14525a0">Past Issues</a> <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU">
<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</a>]
<b>On Behalf Of </b>Robert Timmer-Arends<br>
<b>Sent:</b> Thursday, 13 February 2014 5:32 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] MS Access - Calculated fields<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Hello Damien</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">you may find this discussion useful</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"><a href="http://allenbrowne.com/casu-14.html">http://allenbrowne.com/casu-14.html</a></span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">The update at the end covers Access 2010</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Personally, the only situation I can see that might justify a value that is calculated once and then stored in a field (as Access 2010 seems to do),
is where you need to squeeze every bit of performance out of the dbms that you can; for example, if you had a truck load of data that had to be pulled frequently, calculating a new value each time (either by query or on the fly like FileMaker) could slow retrieval
down. But I can't see that happening on modern equip unless you have a lot of data, and/or maybe an overworked remote server?</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Regards</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Robert T-A</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Brighton SC</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid black 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">----- Original Message -----
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:#E4E4E4"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">From:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">
<a href="mailto:Damien.ATKINSON-BUCK@ivanhoe.com.au" title="Damien.ATKINSON-BUCK@ivanhoe.com.au">
ATKINSON-BUCK, Damien</a> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">To:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">
<a href="mailto:itapps@edulists.com.au" title="itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing List</a>
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Sent:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"> Thursday, February 13, 2014 1:38 PM<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Subject:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"> [Year 12 IT Apps] MS Access - Calculated
fields<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Hi folks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;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></p>
<p class="MsoNormal"><span style="font-size:10.0pt;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></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Cheers<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Damien<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Times New Roman","serif";color:#880231;mso-fareast-language:EN-AU"><br>
</span></b><b><span style="font-size:12.0pt;font-family:"Arial","sans-serif";color:#82002C;mso-fareast-language:EN-AU">Damien</span></b><b><span style="font-size:9.0pt;font-family:"Times New Roman","serif";color:#880231;mso-fareast-language:EN-AU">
</span></b><b><span style="font-size:12.0pt;font-family:"Arial","sans-serif";color:#880231;mso-fareast-language:EN-AU">Atkinson-Buck</span></b><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU">Head of Learning Area: Technology/Arts</span><span style="font-size:8.0pt;font-family:"Times New Roman","serif";color:black;mso-fareast-language:EN-AU">
<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt 36.0pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU">p:</span></b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU"> +61 3 9490 3848</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</td>
<td style="padding:.75pt 36.0pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU">e:</span></b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU">
<a href="mailto:damien.atkinson-buck@ivanhoe.com.au">damien.atkinson-buck@ivanhoe.com.au</a></span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU">f:</span></b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU"> +61 3 9490 3490</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU">w:</span></b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black;mso-fareast-language:EN-AU">
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"><a href="http://www.ivanhoe.com.au"><span style="color:black">www.ivanhoe.com.au</span></a><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><img border="0" width="750" height="105" id="_x0000_i1026" src="cid:image002.jpg@01CF499C.F886BFA0"><br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Please consider the environment before printing this e-mail.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><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. <o:p></o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU">_______________________________________________<br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - 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">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br><br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<o:p></o:p></span></p>
</blockquote>
<p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether
caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender,
and not necessarily those of the Department of Education and Early Childhood Development.<o:p></o:p></p>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.</p>
</body>
</html>