Teaching Resources for your Classroom

Using Your Skills - Aggregate Functions and Calculated Fields in MS Access 2013/16 - UPDATED Aug 2018

Using Your Skills - Aggregate Functions and Calculated Fields in MS Access 2013/16 - UPDATED Aug 2018
Top Product
Our Price: £45.00

This pack contains 20 tasks covering the use of aggregate functions and calculated fields in MS Access queries and reports. The tasks require students to set up a variety of calculated fields using + (plus), - (minus), * (multiply) and / (divide). Students are also required to query using aggregate functions namely: SUM; AVERAGE; MIN; MAX; and COUNT. Students are provided with databases within which relationships are already set up.


NOTE: This pack is a re-write of Pack 05/61 and has now been updated to Office 2013/16 with a few structural changes to the files and with some new exam style questions at the end to better prepare candidates for the new arrangement.
 

Order online and download your product immediately, payable on invoice no credit cards required.
New customers subject to verification.

People who purchased this also purchased...

Forms and Reports in MS Access 2010
14/229 More Info
Our Price: £50.00 (ex VAT)
Plenty of Practice in Complex Spreadsheets - MS Excel 2010
14/240 More Info
Our Price: £50.00 (ex VAT)
MS Excel 2010: Advancing Formulae and Functions
Pack 12/204 More Info
Our Price: £50.00 (ex VAT)
Designing Forms in MS Word 2010
14/245 More Info
Our Price: £45.00 (ex VAT)
Different types of queries in MS Access 2010
14/228 More Info
Our Price: £50.00 (ex VAT)
Practice Assignment Assessment for N5 Admin and IT 2013/14 UPDATED 2018
14/273 More Info
Top Product
Our Price: £40.00 (ex VAT)
Plenty of Practice in Database Forms and Reports in MS Access 2010
14/231 More Info
Top Product
Our Price: £45.00 (ex VAT)
Using your skills packs for N5 Admin and IT - Spreadsheets *UPDATED*
14/274 More Info
Our Price: £45.00 (ex VAT)
Using your skills packs for N5 Admin and IT - Databases *UPDATED*
14/275 More Info
Our Price: £45.00 (ex VAT)