Course outline for Microsoft Windows & Access Course Duration:
1 Months (22 working days)
Day 1, 2 & 3 Computer Definition, Generation of Computers, Identifying Screen Elements, Importance of Office Automation, Application of Computers in Govt. and Private Sector Understanding Program Screen, Filling out Dialog Box, Multiple Windows, Opening & Modifying Database Objects, Discussion with course end objectives, scheduling. Day 4 & 5 Introduction to Software with its applications. Differentiating between High Level and Low Level Programming Languages Creating a Blank Database, Modifying Table and Understanding Data Types, Creating a New Table form Scratch, Query, AND Or Operators Day 8 & 9 Internal Processing of Computer (Main Board and its components, Slots, Chips, Processors, Operating System, Drivers, Ports, BIOS, Serial and Parallel Ports) Preparing Reports . Day 10 & 11 Finding, Advance Filtering , Formatting Data, Freezing Field.
Page 1 of 2
Day 12 & 13 Tables, Indexing, Primary Key, Validating Data, creating Input Mask, Lookup and Value List. Day 14 & 15 Creating Relational Databases Day 16 & 17 Working with Queries, Creating a Calculated Field IIF Functions, Parameter Queries, Crosstab Queries, Make-Table Queries, etc Working with Forms, Controls, Properties, Subforms etc., Day 18 & 19 Understanding the Concepts and Applications of Reports Working with Macros Full Filling deficiencies. Day 20, 21 & 22 Windows Environment Introduction. Features and Difference between Win 98, me, 2000 Professional, XP Working with Mouse: Use of Calculator, Paint, Identifying RAM, Processor, Sound Card, VGA Card Name etc,. Checking Free Hard Disk Space, Disk Clean Up, Disk Defragmenter, Screen Savers, Tiling the Windows Vertically and Horizontally, Creating Short Cuts, Changing Icons of Short Cut, Final Test / Revision of basic concepts / handling practical projects Working with interactive tutors / CD ROM / Floppy Drive / Zip Utilities
Page 2 of 2