Computer Science
Practical:
XI
Student’s Name: _______________________________ Class: ____________________
Roll No.___________________________ Exam No: _________________
Institute: ________________________________________________________________
This is certified to be the bonafide work of the student in the
_____________________________________ Laboratory during the academic year 20
_____ 20_____.
Number of practical certified _____________________ out of ___________________ in the
subject of ___________________________________________________.
Teacher In-Charge
1 | Page
Computer Science
Practical:
XI
Examiner’s Signature Principal
2 | Page
Computer Science
Practical:
XI
Index of Practical
S.No SLO No Practical Activity Page No Practical Signature
Date
1. 8.2.1 Creating different tables in design view and 4
wizard.
2. 8.2.2 Assign appropriate data types to the fields in 6
a table.
3. 8.2.6 Sorting records in a table. 8
4. 8.2.4 Create relationship among tables using 10
primary and foreign key.
5. 8.3.1; Create simple forms using wizards and design 12
8.3.2 view.
6. 8.3.5 Navigating through records in a form. 14
7. 8.3.6; Using forms to add, delete or modify a 16
8.3.7; record.
8.3.8
8. 8.4.1; Create simple queries (select, update, delete 18
8.4.2; and append) using wizard and design view.
8.4.3;
8.4.4;
8.4.5
9. 8.5.1; Write simple SQL (DDL and DML) queries. 20
8.5.2
10. 8.5.1 Create reports using wizard. 22
11. 8.5.4 View and print reports
3 | Page
SLO No Science
Computer 8.2.1
Practical Activity Creating different tables in design view and wizard. Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Students will be able to apply:
● Creating different tables in design view and wizard.
Practical No 1
1. Create a new database with the name of studentsinfo.
2. Create table in design view follow given below details.
3. Create a table name student_main
4. Define Std_ID as a Primary Key in student_main Table
5. Create another table Student marks
6. Define Std_ID as a Primary Key in Student marks Table
Fieldname Data type Description
Std_ID
Sname
Fname
Address
Phone
DOB
NIC
Fieldname Data type Description
Std_ID
English
Urdu
Math
Science
4 | Page
Computer Science
Practical:
XI
Computer
Islamiyat
* Take the screenshots and place it on the next page.
Screen Shot of created documents
5 | Page
Computer Science
Practical:
XI
6 | Page
SLO No Science
Computer 8.2.2
Practical Activity Assign appropriate data types to the fields in a table. Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Students will be able to apply:
● Assign appropriate data types to the fields in a table.
Practical No 2
Assign appropiate data type of the given filed name.
Fieldname Data type Description
Std_ID Number
Sname Short text
Fname Short text
Address Short text
Phone Short text
DOB Date and time
NIC Short text
Fieldname Data type Description
Std_ID Number
English Number
Urdu Number
Math Number
Science Number
Computer Number
Islamiyat Number
* Take the screenshots and place it on the next page.
7 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
8 | Page
Computer Science
Practical:
XI
9 | Page
SLO No Science
Computer 8.2.6
Practical Activity Sorting records in a table. Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Students will be able to apply:
● Sort Sname in Ascending Order
Practical No 3
1. Insert atleast 5 records in the student_main and student marks
2. Sorting Sname records in ascending order
Fieldname Data type Description
Std_ID Number
Sname Short text
Fname Short text
Address Short text
Phone Short text
DOB Date and time
NIC Short text
10 | Page
Computer Science
Practical:
XI
* Take the screenshots and place it on the next page.
Screen Shot of created documents
11 | Page
Computer Science
Practical:
XI
12 | Page
SLO No Science
Computer 8.2.4
Practical Activity Create relationship among tables using primary and foreign key. Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to create relationship between two tables.
Practical No 4
1. Create relationship between student main and student marks table.
2. Just relationsihp between [std_id] of student main table with [std-id] of student marks table.
3. Take a screenshot of relationship screen and datasheet view.
* Take the screenshots and place it on the next page.
13 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
14 | Page
Computer Science
Practical:
XI
15 | Page
SLO No Science
Computer 8.3.1; 8.3.2
Practical Activity Create simple forms using wizards and design view. Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to create a form by using form wizard.
Practical No 5
1. Use Student main table
2. Create a form by using form wizard option.
3. Save form with the name of [student form]
* Take the screenshots and place it on the next page.
16 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
17 | Page
Computer Science
Practical:
XI
18 | Page
Software Science
Computer MS Access 2007 or above
SLO No 8.3.5 Practical:
XI
Practical Activity Navigating through records in a form.
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to edit created form by using form in design view
Practical No 6
1. Open student form
2. Change the layout of the student form using layout view
3. Again Save the form
* Take the screenshots and place it on the next page.
19 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
20 | Page
Computer Science
Practical:
XI
21 | Page
SLO No Science
Computer 8.3.6; 8.3.7; 8.3.8
Practical Activity Using forms to add, delete or modify a record. Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to insert, delete and modify records using form.
Practical No 7
1. Open student form
2. Open form view option and insert new student records using form
3. Again Save the form
* Take the screenshots and place it on the next page.
22 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
23 | Page
Computer Science
Practical:
XI
24 | Page
SLO No Science
Computer 8.4.1; 8.4.2; 8.4.3, 8.4.4, 8.4.5
Practical Activity Practical:
Create simple queries (select, update, delete and append) using wizard and design
view.
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to apply queries select, update, delete and append.
Practical No 8
1. Create a table called "employees" with the following fields: employee_id (AutoNumber, Primary Key),
first_name (Text), last_name (Text), email (Text), hire_date (Date/Time), and salary (Currency).
2. Insert five records using insert query.
3. Display the employee with the employee_id of 2
4. Update the salary of the employee with the employee_id of 4 to $90,000:
5. Delete last record
* Take the screenshots and place it on the next page.
25 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
26 | Page
Computer Science
Practical:
XI
27 | Page
SLO No Science
Computer 8.5.1
Practical Activity Write simple SQL query using (DML and DDL) Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to apply SQL DML and DDL query
Practical No 9
1. Open last practical file
2. Sort records decending order using GROUP BY statement.
3. Select all records from employee table
* Take the screenshots and place it on the next page.
28 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
29 | Page
Computer Science
Practical:
XI
30 | Page
SLO No Science
Computer 8.5.2
Practical Activity Write simple SQL query using (DML and DDL) Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to apply SQL DML and DDL query
Practical No 10
1. Open last practical file
2. Rename the emploee table name using alter table.
* Take the screenshots and place it on the next page.
31 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
32 | Page
Computer Science
Practical:
XI
33 | Page
SLO No Science
Computer 8.5.3, 8.5.4
Practical Activity Create and view reports using wizard Practical:
XI
Equipment Computer and Printer
Software MS Access 2007 or above
Topic 8: Database Development (MS Access 2007 or Above)
Objective:
Student will be able to understand how to apply SQL DML and DDL query
Practical No 11
1. Open employee table
2. Create report of employee table
3. Insert logo on the top of the report
4. Insert date on the bottom of report
* Take the screenshots and place it on the next page.
34 | Page
Computer Science
Practical:
XI
Screen Shot of created documents
35 | Page
Computer Science
Practical:
XI
36 | Page
Computer Science
Practical:
XI
37 | Page
