[Year 12 IT Apps] MS Access - Calculated fields

[Litsa Tzelepis]

Oh never in a table. In a query only. I missed that bit in the original
message. I agree fully.

On Wednesday, March 26, 2014, Natalie H <natinga71 at yahoo.com> wrote:

> I'd never store a calculated field in a table. Queries all the way.
>
> Natalie Heath, Parade College
>
> Sent from my iPad
>
> On 26 Mar 2014, at 8:27 pm, 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> 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 [
> mailto: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
>
>

-- 
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/924de59e/attachment.html