Page 200 - BSIT Course Syllabus (First Sem 2020-2021)

7 After the completion of VII. Microsoft Access Discussion Online Lecture Laboratory Before the
the unit, the students will engaging to SQL Learning (Power Point Activity 6 end of week
be able to: output (I) Presentation Presentation) 8th week
1. Creating
1. familiarize on A. Creating database Demonstration/ Modules database and
LibreOffice Base IDE; in MS Access Simulation inserting of data in
2. create and use a B. Creating Table Learning database table.
database in MS C. Inserting data Guide
access; and 2. Creating
3. modify a table in the Computer/ Database using
database. Laptop/ MS Access
mobile
phone
8 After the completion of VII. Microsoft Access Discussion Online Lecture Laboratory Before the
the unit, the students will engaging to SQL Learning (Power Point Activity 7 end of week
be able to: output (II) Presentation Presentation) 8th week
3. Designing a
4. Design a relational D. Relational Demonstration/ Modules relational
database. Database Simulation database.
5. Modify field Learning
properties of table Guide
and create views. 4. Modifying field
Computer/ properties of
Laptop/ tables
mobile and viewing
phone outputs
9 MIDTERM EXAMINATION
10 After the completion of VIII. Advance Database Discussion Online Lecture Laboratory Before the
the unit, the students will Usage Learning (Power Point Activity 8 end of week
be able to: Presentation Presentation) 10th week
A. Create a query in 1. Creating
1. apply basic queries design, wizard and Demonstration/ Modules database form
using MS Access; SQL view. Simulation and applying
2. create reports using B. Basic queries. Learning attributes and
MS Access; and C. Creating reports Guide primary key.

V02-2020-07-01