[Year 12 IT Apps] formulas for Access 2010 queries

[Joyce Tabone]

Hi all

I agree with Mark's interpretation and have only shown my students creating a calculated field within a query, for example if a query has the fields costLabour plus costMaterials and I needed the total cost,I can create a new field in a query

Total:[CostLabour]+[CostMaterials]





Joyce Tabone
Head of Faculty ICT and Website Editor
Aiken College
1010 Mickleham Road
Greenvale VIC 3059
Tel: (03) 9333 1866



-----Original Message-----
From: Mark Scott [mailto:msc at luther.vic.edu.au]
Sent: Mon 5/16/2011 3:02 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] formulas for Access 2010 queries
 
>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



-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 4179 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20110516/d1fdfe5c/attachment-0001.bin