Friday, 20 March 2015

Ms Access Exercise 1



Access Exercises
1.      Create the following data table  in Access
Group
Gender
Homework1
Homework2
Homework3
Technical
Male
92
84
93
Administrative
Female
77
84
85
Technical
Male
87
86
81
Administrative
Female
89
90
93
Technical
Male
64
73
78
Technical
Female
81
84
93
Administrative
Male
83
90
91
Administrative
Female
84
88
86
Administrative
Male
82
80
78
Administrative
Female
96
91
88

2.      Create a form and then add your own 4 records.
3.      List all the males
4.      Using the select query, list all the females who are in the Administrative group
5.      Using the select query, list all the males who are in the Technical group
6.      List all people who scored > 60 in Homework1 and < 80 in Homework3
7.      Create a report from the above table
Propellerads