Year 8 ICT Help Desk
Tuesday, March 8, 2016
Wednesday, March 2, 2016
Database Reports
Tune in to today's lesson objectives (5 Minutes)
You should know before starting today's activity (5 Minutes)
Difference between a form and a ReportTasks of the Day (15 Minutes)
Task 1
1) Generate a Result Sheet (from a single
table )
a) 3 subjects
b) 10 students
Task 2
2) Generate a Stock Report (from a single
Table)
a) Show Item Code , Item Name, Cost, Quantity
in Stock
Challenge
3) Generate a Sales Report (from 2 tables)
a) Show Item Code , Item Name, Quantity Sold,
Cost, Sale Price
Subscribe to:
Comments (Atom)