[Year 12 IT Apps] Suggestion for a teacher resource..

[Kent Beveridge]

Hi all,
Obviously, there are many of you guys and gals out there who have great skills with database queries, validation techniques etc, so...
how about if a 'database of subroutines', using for example, some of the query routines just posted in answer to other's questions, could be created.
Would this be in breach of any rules Kevork? This way, we could allow those who use 'non-proprietary' database programs(non-Access!) as well as Access to be able to access some quick solutions that we are coming across. After all, professional programmers store a database of subroutines and call them up then modify them to suit the project or application.
Surely this is encouraging good practice whilst assisting others at the same time.  What do you think folks?
 
This could also apply to some of the other software based applications we need to teach our students during the year for the other outcomes too. Hopefully, this does not breach any VCAA rules.
This does not need to be subject specific.
 
Kent Beveridge,
I.T. to years 8-12
St. Brigids Catholic Sec. College
Horsham
 
"This email and any attachments may be confidential.  You must not disclose or use the information in this email if you are not the intended recipient.  If you have received this email in error, please notify us immediately and delete the email and all copies.  The School does not guarantee that this email is virus or error free.  The attached files are provided and my 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 content and opinions in this email are not necessarily those of the School."

________________________________

From: itapps-bounces at edulists.com.au on behalf of Kevork Krozian
Sent: Tue 13/03/2007 10:26 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Access question


Hi Mark,
 
 A table ( Table1) with 4 fields ( ID, name, surname, suburb and postcode ).
We want to count how many times a suburb occurs and order from highest to lowest.
 
Create a new query, Add the table to the grid,  click on View , SQL view, paste in the following:
 
SELECT Table1.suburb, Count(*) AS num_suburbs
FROM Table1
GROUP BY Table1.suburb
ORDER BY Count(*) DESC; 
 
Run and the output is attached as well as screen grabs of the table and the query grid in design view.
 
Desc stands for descending, so order by most numerous to least numerous. 
Hope this helps
 
 
Kevork Krozian
Mailing List Creator and Administrator
kevork at edulists.com.au
www.edulists.com.au <http://www.edulists.com.au/> 
Tel: 0419 356 034

	----- Original Message ----- 
	From: Jones, Mark A <mailto:jones.mark.a at edumail.vic.gov.au>  
	To: itapps at edulists.com.au 
	Sent: Tuesday, March 13, 2007 2:14 PM
	Subject: [Year 12 IT Apps] Access question

	Dear all
	 
	I'm looking for a function (for a query or report) that will search a list of names then provide the name of the most numerous one. Any ideas would be appreciated.
	 
	regards
	Mark Jones
	Cann River P-12 College

	

	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.

	_______________________________________________ 
	http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
	IT Applications Mailing List kindly supported by 
	http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and 
	http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc

_______________________________________________ 
http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au <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: 9104 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070314/32310789/attachment-0001.bin