(042) 3578 5580

Database Management System

At the end of this course the students will be able to make a software based on MS Access Database i.e., Library Management System, Student Record Information System etc.

Duration: 2 Months
Lectures:: 3 Classes per week
Lecture Duration 90 Minutes
Fee PKR 8,000/-

Course Contents:
• The candidate will be able to
• Introduction: Course overview, a quick overview of MS Access for windows. Database theory: Define a database, table, record, field, data types, key fields, indexes and object in Access.
• Creating tables I: Define the table structure, data entry.
• Creating tables II: Copying and restructuring the table design, modifying the field properties, using formats and input masks. Renaming and deleting tables.
• Importing and Exporting Data Relationships Database Management organisation: Data sorting, indexing and validation.
• Creating Forms: Creating forms from scratch, changing the field properties on the form, calculations on forms, data entry forms.
• Using the form wizards.
• Creating Queries: Introduction to the different query types. Writing Select queries using: Logical Operators: And, Or, Not and Null. Mathematical operators and calculations.
• Creating queries for: Global Delete, change and insert, Making Tables and Appending Tables.
• Creating Reports: Creating reports from scratch, Report headers and footers, calculations on reports. Using the form wizards to create mailing lists.
• Creating Advanced/complex Forms/Reports: Creating Main/ Sub-reports from scratch. Graphs in reports/forms.
• Modules: Creating VBA code.
• Database Administration and Security.

Note: 40% discount for SCOCS students.
To book your seat, contact:
Ms. Sadaf Jahangir
Mobile no. 0300-4722996 / 0336-6782755