SEE Database Practical - MS Access

A. Create a database "school". Create a table "student" with following fields(Design View).

Field Name	Data type
StudentID	Autonumber
StudentName	Text
Class	Number
English	Number
Nepali	Number
Computer	Number

1. Make StudentID as primary key.
2. Set Caption "Eng Mark" , "Nep Mark" and "Comp Mark".
3. Set default value 10 for field class .
4. Set the validation rule: >=0 AND <=100
5. Set the validation text : Enter the marks between 0 to 100.
6. Enter any five data in table "student".[Datasheet View]

B. Create following queries:

1. Display all records of table "student".
2. Display all records in descending order of marks of Computer.
3. Display all those records, where the mark in "English" are greater than or equal to 80.
4. Display all those records where marks in all subjects are greater than or equal to 80.
5. Display all those records where student name start with "A" or "S".
6. Display all the records for those students whose marks in "Computer" are between 60 to 80.
7. Display records by student ID.
8. Delete the records of "abc" student.
9. Update the marks of English by 10 to all students.
10. Calculate total by adding marks of Eng, Nepali and Computer.
11. Calculate Average by dividing total by 3.
12. Make remarks if average marks is greater than or equal to 40 then "Pass" , otherwise "Fail".

C. Create form of table student using form Wizard.

D. Add two more records using Form crated above.

E. Make a report of table "student".

F. Make a report of query "q7 " created above.