[Year 12 IT Apps] formulas for Access 2010 queries

[Mike Brookes]

G'Day again
'Tis true that you shouldn't use a formula in a table, however you can 
use calculated fields in an input form, query or report eg. 
TotalCost:[Quantity]*[Price]
Your query could then select on TotalCost > SomeAmount to select records 
eligible for a discount or somesuch.
Functions such as DateDiff, Like (including wild characters), DatePart, 
Year, Month and Date are useful in selection criteria together with the 
standard boolean operators.
I thought that the "Search Criteria" help was pretty straight forward 
but if your little dears resist reading as much as mine did then copy 
and paste the help and delete anything you don't think would be 
appropriate. If one of the students wants to do a query which needs some 
of the other examples you can always point them to the original help.

Mike


On 16/05/2011 3:02 PM, Mark Scott wrote:
>
> *From VCAA:*
>
> *Relational database management system*
> The following functions apply to Unit 3:
>
> ·create tables
>
> ·create relationships between tables
>
> ·use a range of data types
>
> ·electronic validation
>
> ·create, edit and use queries
>
> ·use of calculated fields
>
> ·sort records or index on different fields.
>
> Given that putting formulas into tables is not standard practice then 
> we are left with the formulas in queries.
>
> eg [Quantity]*[Price]
>
> Mark Scott
>
> Luther College
>
> *From:*itapps-bounces at edulists.com.au 
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Margaret King 
> Iaquinto
> *Sent:* Monday, 16 May 2011 2:30 PM
> *To:* 'Year 12 IT Applications Teachers' Mailing List'
> *Subject:* Re: [Year 12 IT Apps] formulas for Access 2010 queries
>
> Mark and Mike
>
> What formulas are we expected to teach? I am using Access.
>
> Maggie
>
> VK3CFI
>
> *On Mon May 16 12:16 , Mark Scott sent:*
>
> Mike
>
> Thanks, thatR17;s great but I was hoping someone might have a simpler 
> version that would be less daunting for my students.
>
> Mark Scott
>
> Luther College
>
> R20;We are what we pretend to be, so we must be careful what we 
> pretend to beR21;
>
> *From:*itapps-bounces at edulists.com.au 
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Mike Brookes
> *Sent:* Monday, 16 May 2011 1:56 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] formulas for Access 2010 queries
>
> Hi Mark et Al
>
> If you click on the help button at the top right of the screen, type 
> "query criteria" in the search box, then select "Examples of search 
> criteria" you will get a summary which includes a few tables showing 
> functions which can be used in queries plus several examples of their use.
>
> Mike Brookes
> Semi retired gentleman
> Copperfield College
>
>
> On 16/05/2011 12:32 PM, Mark Scott wrote:
>
> Hi all
>
> I am hoping someone will have a summary of formulas for Access 2010 
> queries that they would be willing to share.
>
> Mark Scott
>
> Luther College
>
> R20;We are what we pretend to be, so we must be careful what we 
> pretend to beR21;
>
>   
>   
> _______________________________________________
> 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 and
> http://www.vitta.org.au   - VITTA Victorian Information Technology Teachers Association Inc
>
>
> _______________________________________________
> 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 and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110516/71cf3eb2/attachment.html