<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Also what he said.</div><div><br></div><div>I always considered Access tables as the storage point for data, while queries are the means to display the information. That means you can store the data in the most efficient manner without regard to the information intended for display. This also allows for that data to be used easily to display information not anticipated when the DB is created.</div><div><br></div><div>John Schwartz</div><div>Retired<br><br>Sent from my iPad<div><br></div><div>John S. Schwartz</div></div><div><br>On 14 Feb 2014, at 9:20 am, "Mark Scott" <<a href="mailto:msc@luther.vic.edu.au">msc@luther.vic.edu.au</a>> wrote:<br><br></div><blockquote type="cite"><div><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (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: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;}
@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.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;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","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;}
/* List Definitions */
@list l0
{mso-list-id:1772360250;
mso-list-type:hybrid;
mso-list-template-ids:-802520352 201916417 201916419 201916421 201916417 201916419 201916421 201916417 201916419 201916421;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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]--><div class="WordSection1"><p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span style="color:#1F497D">What he said.<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">Mark Scott<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"><o:p> </o:p></span></p><div><p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-AU"> <o:p></o:p></span></p></div><p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-AU"> </span><span style="color:#1F497D"><o:p></o:p></span></p><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"><luther_college_email4d32ad></font></a></td></tr></tbody></table><p></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><div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="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>Stuart Walkerden (STUW)<br><b>Sent:</b> Friday, 14 February 2014 8:33 AM<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">Good Morning everyone<o:p></o:p></span></p><p class="MsoNormal"><span style="color:#1F497D">I have often told my students with respect to Microsoft “Just because you can doesn’t mean you should”. I reckon we should continue to use queries for calculated fields for the following reasons:<o:p></o:p></span></p><p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><!--[if !supportLists]--><span style="font-family:Symbol;color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span><!--[endif]--><span style="color:#1F497D">The VCAA website states that students should “create, edit and use queries”. We can sort in tables and sort and group in reports, so although in Access we may not need queries, we must teach students to use them.<o:p></o:p></span></p><p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><!--[if !supportLists]--><span style="font-family:Symbol;color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span><!--[endif]--><span style="color:#1F497D">My understanding of normalisation is that we remove fields dependent on other fields (i.e. calculated fields). </span><b><span style="color:red">Question 9 on the 2012 exam and the examiner’s report, expects students to remove calculated fields as part of normalisation.</span></b><span style="color:#1F497D"><o:p></o:p></span></p><p class="MsoNormal"><span style="color:#1F497D">Cheers <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">Stuart Walkerden<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"> <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>ATKINSON-BUCK, Damien<br><b>Sent:</b> Thursday, 13 February 2014 1:39 PM<br><b>To:</b> Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> [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="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"><image001.jpg><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></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe</span><br><span>IT Applications Mailing List kindly supported by</span><br><span><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></span><br><span><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br></span><br><span><a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</span></div></blockquote></body></html>