COMPUTER SCIENCE PORTFOLIO
COLLEGE NAME:
PRINCE ALY HIGHER SECONDARY SCHOOL
PREPARED BY:
MUHAMMAD UMER SHAHZAD
XI-B
1
NO. DATE EXPERIMENT PAGE INTIAL SIGNATURE
1 Practical 1 (Table Design, Data Types and Field Properties)
22-3-2025 Create a database in MS-Access of Student Information 3
2 Practical 2 (From Wizard)
22-3-2025 Create a database in MS-Access for a Vehicle database 6
3 Practical 3 (One to One Relationship)
22-3-2025 Create a database in MS-Access of Bank Accounts. 7
4 Practical 4 (One to Many Relationship)
23-3-2025 Create a database in MS-Access for school. 9
5 Practical 5 (Query Design View)
23-3-2025 Create a database in MS Access for Hospital 10
6 Practical 6 (Query Wizards, Sorting and Applying Criteria using Design View
23-3-2025 Create a database of Library 13
7 Practical 7 (Create, Alter, Drop Table Using SQL)
23-3-2025 Create a database in MS-Access for Citizens. 16
8 Practical 8 (SQL DML Select and Delete)
23-3-2025 Create a database in MS Access of Employee Information 18
9 Practical 9 (SQL DML Insert and Update)
23-3-2025 Create a database in MS Access for Cricket 20
10 Practical 10 (Calculated Fields using SQL)
23-3-2025 Create a payroll database. 22
11 Practical 11 (Forms in Design View)
24-3-2025 Create a database in MS Access for Student Result 24
12 Practical 12 (Reports Using Wizard)
24-3-2025 Create a Database Expenditure 27
2
- Practical 1 (Table Design, Data Types and Field Properties)
- Create a database in MS-Access of Student
Information
Create table STUDENT, the fields are as follows;
SID, Name, Class, Address, CNIC, City, Email, DOB and set the following properties
Set SID as primary Key and set caption property for ‘SID as ‘Student Identity’.
Set field size of name up to 50 characters and set it as ‘not null’.
Produce a list of available values using look up wizard in the field class.
Give CNIC short text data type and apply input mask as 00000-0000000-0
Give default value in the city as ‘Karachi’.
Apply no duplication on Email.
Apply ‘medium date’ format to DOB.
Enter 5 Records in the table.
………………………………………………………………………………………………………………………………………………………
3
4
- Practical 2 (From Wizard)
- Create a database in MS-Access for a Vehicle database
Create table Vehicle (RegNo, BrandName, Model, Color)
Create a from using wizard with tabular layout.
Enter 15 Records in the table using form.
……………………………………………………………………………………………...............
5
Practical 3 (One to One Relationship)
Create a database in MS-Access of Bank Accounts.
Create 1st table ACCOUNT(AccNo, Acc_Title, Acc_Address, Acc_Phone, Acc_Email)
Create 2nd table STATUS(StatusID, AccNo, Acc_Status, Balance) with suitable data types.
Create one to one relationship between the tables.
Enter 5 Records from parent table to child table.
……………………………………………………………………………………………………………………………….
6
7
Practical 4 (One to Many Relationship)
Create a database in MS-Access for school.
Create 1st table student (SID, Name, Class, CellNo, Email)
Create 2nd table Attendance (AID, SID, Month Name, Year, Working Days, Present Days)
Create one to many relationship between the tables.
Enter 5 Records in the table student and related 2 records for each parent record in attendance
table.
……………………………………………………………………………………………………………………………….
8
Practical 5 (Query Design View)
Create a database in MS Access for Hospital
Create table Patient (Patient_ID, Patient Name, Gender, DOB, Diagnosis, Prescpription,
Doctor Name, DOT) with appropriate data types and suitable primary key & enter 10
records.
Create queries in design view the following names and purposes:
TB Patients: Displays the records of male patients who have TB diagnosed.
Started by M: Display the name and gender of male patients whose names are
started by ‘M’.
Fever Patients: Display the records of patients who are having Dengue, Malaria
or Typhoid.
2022 to 2024 Patients: Display the records of patients who were treated during
1/01/2022 to 1/01/2024.
55 Years Old Females: Display the record of females who are older than 55 years
on 12/31/2023.
9
Without Prescription: Display the records of all the patients who have not
prescribed any medicine.
Other than Dr. Ahmed: Display the list of patients who are not treated by Dr.
Ahmed.
……………………………………………………………………………………………………………………………….
10
Practical 6 (Query Wizards, Sorting and Applying Criteria using Design View)
Create a database of Library
Create table books (Book_Id, Title, Publisher Name, Author Name, Issued) with
suitable datatypes.
Create a suitable primary key and input 5 different records.
Sort records in ascending order by author name.
Create a query in design view for the following;
Display a list of books sorted by Title in ascending order.
Display a list of books, published by other than Dogar Brothers/Majeed Sons.
Display a list of books where there is no Author Name.
11
Display a list of books where Authors’ name starts with ‘M’ and issued is ‘Yes’.
……………………………………………………………………………………………………………………………….
12
Practical 7 (Create, Alter, Drop Table Using SQL)
Create a database in MS-Access for Citizens.
Create table Citizens (CNIC, Name, DOB, Address, Phone, Email) taking suitable data
types using CREATE statement.
Set CNIC as Primary Key and Name as Not Null.
Insert 4 records in the table using insert statement.
Change the structure of the table using ALTER statement and add field of city and
country.
Open the table in data sheet view and enter cities and countries.
Remove the field of country using DROP statement.
Enter two more records in the table using datasheet view.
Write SQL statement to delete the table.
……………………………………………………………………………………………………………………..
13
14
15
16
