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. Solutions are provided in soft copy and hard copy format.

£7.50