Practical Questions
Field Name
Data Type
Description
StudentID
AutoNumber
Primary Key
FullName
Short Text
Full Name of the student
Gender
Short Text
Male/Female
DateOfBirth
Date/Time
Birth date
Class
Short Text
Class enrolled
1. Create the database name students and the two tables above.
2. Enter the following sample data:
Student data
FullName
Gender
DateOfBirth
Class
Ali Farah
Male
2003-05-11
Form 4
Nimo Abdi
Female
2004-09-23
Form 3
Yusuf Mohammed
Male
2002-12-14
Form 4
Results data
StudentID
Subject
Marks
ExamDate
1
English
78
2025-06-01
1
Math
82
2025-06-01
2
English
65
2025-06-01
3
Science
88
2025-06-01
Questions for Students
1. Create a query to display all students with their marks in English.
2. Create a form to the results table easily.
3. Create a report in the student table.
4. What is the highest score in Math?
5. Which student scored the lowest in English?
Field Name
Data Type
Description
ResultID
AutoNumber
Primary Key
StudentID
Number
Foreign Key from Students
Subject
Short Text
Subject name
Marks
Number
Marks scored
ExamDate
Date/Time
Date of the exam
