MS access query and oga

OGAs

Grade 6

https://forms.gle/PuTSNux1bqWEfbqC9

Grade 7 - 1ST

https://forms.gle/t5MSJd1x1AHS6rBZ9

Grade 8

https://forms.gle/98rT57noZNZ66vvF9

Create a table named Students with the following fields:

StudentID	FirstName	LastName	Grade	Subject	Score
1	John	Doe	8	Math	85
2	Jane	Smith	8	Science	92
3	Alice	Johnson	8	Math	78
4	Bob	Brown	8	History	88
5	Charlie	Davis	8	Science	90
6	Emily	White	8	Math	95

Grade 8

https://www.educaplay.com/learning-resources/20337433-ms_access.html

Grade 8

https://wordwall.net/resource/70344372/microsoft-access

https://edu.gcfglobal.org/en/access/access-quiz/1/

https://quizizz.com/admin/quiz/5f30c671fe30d3001c916fa1/ms-access-database

MS Access Sample data

Download this File

https://drive.google.com/file/d/1az7uYu7LABaxZxkuSnbBVV_Wq7yYDTaC/view?usp=drive_link

Task # 1:

find students who scored above 85 in Math -

Query name: HighScoringMathStudents


1 mark

Task # 2:

find students who Scored Below 80 in all Subjects -


1 mark

Task # 3:

Query for Top 3 Performers in English -


1 mark

Task # 4:

Whose scores are between 80 and 90 in any subject. -


1 mark