Database Reports

Tune in to today's lesson objectives (5 Minutes)

             Click to see a sample Form

             Click to see a sample Report

             

You should know before starting today's activity (5 Minutes)

             Difference between a form and a Report

Tasks of the Day (15 Minutes)

Task 1

1)     Generate a Result Sheet (from a single table )

      a)     3 subjects

b)     10 students

c)     Click to download database file containing Data Table.

d)     Video Tutorial for Task 1

Task 2

2)     Generate a Stock Report (from a single Table)

a)    Show Item Code , Item Name, Cost, Quantity in Stock   

b)    Click to download database file containing Data Table.

c)    Video Tutorial for Task 2

    

Challenge

3)     Generate a Sales Report (from 2 tables)

a)     Show Item Code , Item Name, Quantity Sold, Cost, Sale Price   

b)     Click to download database file containing Data Tables.

c)     Video Tutorial for Challenge

Celebrate Success 

Plot the Success Chart 

Why the word PEER rhymes with NEAR and DEAR?