[Year 12 IT Apps] MS Access - Calculated fields

[Litsa Tzelepis]

I'm sure calculated fields are in the software tools list though.



On Wednesday, March 26, 2014, John Schwartz <schwartz at melbpc.org.au> wrote:

> I am in total agreement.
>
> Sent from my iPad
>
> John S. Schwartz
>
> On 26 Mar 2014, at 4:44 pm, "Groves, Brett G" <
> groves.brett.g at edumail.vic.gov.au<javascript:_e(%7B%7D,'cvml','groves.brett.g at edumail.vic.gov.au');>>
> wrote:
>
>  Hi all - my 2 centimes
>
>
>
> 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.
>
>
>
> 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?
>
>
>
> 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
>
>
>
> Kind Regards,
>
>
>
> Brett Groves
>
> <image001.gif>
>
> Melba College
>
> eLearning Leader
>
> 03 9725 8277 Ext 221
>
> eLearning Resources for Educators<http://melba.vic.edu.au/curriculum/elearning/>
>
>
> Newsletter sign up<http://melba.vic.edu.au/curriculum/elearning/elearning-newsletter/>
>
>
> Past Issues<http://us7.campaign-archive1.com/home/?u=3552e93cf6fe9d34510f19694&id=1cc14525a0>
>
>
>
>
> *From:* itapps-bounces at edulists.com.au<javascript:_e(%7B%7D,'cvml','itapps-bounces at edulists.com.au');>[
> mailto:itapps-bounces at edulists.com.au<javascript:_e(%7B%7D,'cvml','itapps-bounces at edulists.com.au');>]
> *On Behalf Of *Robert Timmer-Arends
> *Sent:* Thursday, 13 February 2014 5:32 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] MS Access - Calculated fields
>
>
>
> Hello Damien
>
>
>
> you may find this discussion useful
>
>
>
> http://allenbrowne.com/casu-14.html
>
> The update at the end covers Access 2010
>
>
>
> 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?
>
>
>
>
>
> Regards
>
> Robert T-A
>
> Brighton SC
>
>
>
>  ----- Original Message -----
>
> *From:* ATKINSON-BUCK, Damien
>
> *To:* Year 12 IT Applications Teachers' Mailing List
>
> *Sent:* Thursday, February 13, 2014 1:38 PM
>
> *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
>
> <image002.jpg>
> 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.
>  ------------------------------
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>
>  *Important - *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.
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>
>

-- 
Sent from Gmail Mobile

-- 
 

IMPORTANT! This email and any attachments may be confidential. If received 
in error, please contact us and delete all copies. Mount St Joseph Girls' 
College does not represent or warrant that the attached files are free from 
computer viruses or other defects. The attached files are provided, and may 
only be used, on the basis that the user assumes all responsibility for any 
loss, damage or consequence resulting directly or indirectly from the use 
of the attached files, whether caused by the negligence of the sender or 
not. The liability of Mount St Joseph Girls' College is limited in any 
event to either the resupply of the attached files or the cost of having 
the attached files resupplied. Any representations or opinions expressed in 
this email are those of the individual sender, and not necessarily those of 
Mount St Joseph Girls' College.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20140326/a2facd2a/attachment.html