| Course Code |
S 03 |
| Duration |
3 month (Theory 120 Hours - Practical 120 Hours) |
| Prerequisite |
Experience with using a computer and MS Operating system OR completion of the course B 01 (Computers for Beginners) or equivalent.The course is design for the audience with no programming and databases knowledge. |
| Objective |
This course provides conceptual knowledge about programming and use of database. It also provides hands-on experience on VB MS Access. At the end of the course student will do a project. |
|
Module |
Topics |
Hours |
1 |
MS Visual Basic Programming
|
140 Hours |
| |
Features of Visual Basic, Programming Concepts, Logic Building, Basic and Advanced Controls, their properties, Events, Menus and Dialog Boxes, Error Handling, Text File Input/ Output, Database Handling Techniques - OLEDB, DSN, DAO, RDO, ADO, Introduction to COM and ActiveX dynamic link libraries, code components and ActiveX exe , ActiveX Controls. |
|
2 |
MS Access
|
80 Hours |
| |
Introduction to Database, Features of MS -Access, Setting Entity Relations in a Database, Creating Tables, Data Definitions using MS - Access, Setting Constraints in MS- Access table data, Updating data, Data Retrieval, Queries using MS - Access, Report Generations, Data Connectivity of MS Access with VB. |
|
3 |
Project
|
20 Hours |
Total Hours |
240 Hours |
SCIT Evaluation policy: Practical examination |
IT Courses
