[Year 12 IT Apps] MS Access - Calculated fields

[Mark Scott]

What he said.

Mark Scott





Mark Scott
Daily Administrator
Luther
Plymouth Road
Croydon Hills Victoria 3136

Luther
Telephone (03) 9724 2000
Direct Line (03) 9724 2023
www.luther.vic.edu.au<http://www.luther.vic.edu.au/>
        [cid:luther_college_email4d32ad] <http://www.luther.vic.edu.au/>

Please consider the environment before printing this email.

This email and any attachments may contain privileged and confidential information.
If you are not the intended recipient you may not distribute or reproduce this email
or attachments. If you have received this message in error please notify us by return mail.


From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Stuart Walkerden (STUW)
Sent: Friday, 14 February 2014 8:33 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] MS Access - Calculated fields

Good Morning everyone
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:

*         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.

*         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.
Cheers

Stuart Walkerden

From: itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au> [mailto:itapps-bounces at edulists.com.au] On Behalf Of ATKINSON-BUCK, Damien
Sent: Thursday, 13 February 2014 1:39 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] MS Access - Calculated fields

Hi folks,
            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.
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?
Cheers
Damien

Damien Atkinson-Buck
Head of Learning Area: Technology/Arts
p: +61 3 9490 3848

e: damien.atkinson-buck at ivanhoe.com.au<mailto:damien.atkinson-buck at ivanhoe.com.au>

f: +61 3 9490 3490

w: www.ivanhoe.com.au<http://www.ivanhoe.com.au>

[cid:image001.jpg at 01CF2962.BEEDE7F0]
Please consider the environment before printing this e-mail.




Privacy, Virus and Copyright Warning

The information contained in this electronic message (e-mail), and any files transmitted with it:

* 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;
* 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.
* represents the views of the sender and does not necessarily represent the views or formal advice of Ivanhoe Grammar School;
* may be subject to Copyright, so no further use should be made of it without the author's permission.

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20140214/c656d440/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 51301 bytes
Desc: image001.jpg
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20140214/c656d440/image001-0001.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: luther_college_email4d32ad
Type: image/png
Size: 12076 bytes
Desc: luther_college_email4d32ad
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20140214/c656d440/luther_college_email4d32ad-0001.png