<div dir="ltr">Hi Stuart. <div><br></div><div>- The only problem with "<span style="color:rgb(31,73,125)">The VCAA website states that students should “create, edit and use queries” is that - if strictly enforced - it would outlaw the use of Filemaker, which does not have queries as such.</span><div>
<span style="color:rgb(31,73,125)">I think we need to be reasonably flexible in the interpretation of commandments that assume a particular (usually Microsoft-centric) mindset.</span></div><div><span style="color:rgb(31,73,125)"><br>
</span></div><div><span style="color:rgb(31,73,125)">- Regarding your second point about dependent fields, calculated fields are a distinctly different beast to regular storage fields. They are unstored and dynamically calculated, so they probably don't qualify as 'fields' as such even if they appear as such to the user.</span><br>
<div class="gmail_extra"><br><br><div class="gmail_quote">On 14 February 2014 08:33, Stuart Walkerden (STUW) <span dir="ltr"><<a href="mailto:stuw@huntingtower.vic.edu.au" target="_blank">stuw@huntingtower.vic.edu.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="EN-AU" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Good Morning everyone<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">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:<u></u><u></u></span></p>
<p><u></u><span style="font-family:Symbol;color:rgb(31,73,125)"><span>·<span style="font-style:normal;font-variant:normal;font-weight:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman'">
</span></span></span><u></u><span style="color:rgb(31,73,125)">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.<u></u><u></u></span></p>
<p><u></u><span style="font-family:Symbol;color:rgb(31,73,125)"><span>·<span style="font-style:normal;font-variant:normal;font-weight:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman'">
</span></span></span><u></u><span style="color:rgb(31,73,125)">My understanding of normalisation is that we remove fields dependent on other fields (i.e. calculated fields). Question 9 on the 2012 exam and the examiner’s report, expects students to remove calculated
fields as part of normalisation.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Cheers <u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Stuart Walkerden<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-style:solid none none;border-top-color:rgb(181,196,223);border-top-width:1pt;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span lang="EN-US" style="font-size:10pt;font-family:Tahoma,sans-serif"> <a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a>
[mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank">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<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif">Hi folks,<u></u><u></u></span></p>
<p class="MsoNormal"><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.
<u></u><u></u></span></p>
<p class="MsoNormal"><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?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif">Cheers<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif">Damien<u></u><u></u></span></p>
<p class="MsoNormal"><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">
<u></u><u></u></span></p>
<table border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0.75pt 36pt 0.75pt 0.75pt">
<p class="MsoNormal"><b><span style="font-size:8pt;font-family:Arial,sans-serif">p:</span></b><span style="font-size:8pt;font-family:Arial,sans-serif"> <a href="tel:%2B61%203%209490%203848" value="+61394903848" target="_blank">+61 3 9490 3848</a></span><span style="font-size:8pt;font-family:Arial,sans-serif"><u></u><u></u></span></p>
</td>
<td style="padding:0.75pt 36pt 0.75pt 0.75pt">
<p class="MsoNormal"><b><span style="font-size:8pt;font-family:Arial,sans-serif">e:</span></b><span style="font-size:8pt;font-family:Arial,sans-serif">
<a href="mailto:damien.atkinson-buck@ivanhoe.com.au" target="_blank">damien.atkinson-buck@ivanhoe.com.au</a></span><span style="font-size:8pt;font-family:Arial,sans-serif"><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="padding:0.75pt">
<p class="MsoNormal"><b><span style="font-size:8pt;font-family:Arial,sans-serif">f:</span></b><span style="font-size:8pt;font-family:Arial,sans-serif"> <a href="tel:%2B61%203%209490%203490" value="+61394903490" target="_blank">+61 3 9490 3490</a></span><span style="font-size:8pt;font-family:Arial,sans-serif"><u></u><u></u></span></p>
</td>
<td style="padding:0.75pt">
<p class="MsoNormal"><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" target="_blank"><span style>www.ivanhoe.com.au</span></a><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'Times New Roman',serif"><img border="0" width="750" height="105" src="cid:image001.jpg@01CF295E.61296080"><br>
</span><span style="font-size:7.5pt;font-family:Arial,sans-serif">Please consider the environment before printing this e-mail.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'Times New Roman',serif"><br></span></p></div></div></blockquote></div>-- <br><div dir="ltr">--<div>Mark Kelly</div><div>mark AT vceit DOT com</div><div>
<a href="http://vceit.com" target="_blank">http://vceit.com</a></div><div><br></div><div><div><i>Everything that used to be a sin is now a disease - Bill Maher </i></div></div><div><br></div></div>
</div></div></div></div>