Information Systems Execuitive (ISEP)

THE PROGRAMME

This program provides a comprehensive knowledge of Office Packages & Networking. Spreadsheet Applications, Advanced Database Management & practical networking that could help an office executive to work with modern information systems.

Formulas & Functions       
Range Names
Conditional Functions
Nested Functions
Array Formulas     

Filtering Data       
AutoFilters
Advanced Filters
Macros       
Recording Macros
Macro Buttons
Edit Macro using the VB Editor
Forms         
Designing a Form
Form Controls
Linking a Form to a Database     
Advanced Database Management     

Database Concepts       
Database Designing using Access
Tables (Data types, assigning keys, validation of fields…)
Relationship between tables
Referential Integrity
Structured Query Language
Form Designing         
Adding Components
Switchboard Manager
Events, Macros and Modules

Reports       
Sorting & Grouping
Calculated fields
Graphical Interpretation
Database Administration       
Database Security
Converting Database formats
Database Compact & Repair / Making MDE file
Introduction to Programming using Visual Basic            

Introduction to Computer Networking       
1. LAN & WAN
2. What is ISO / OSI & TCP / IP
3. Network Devices
4. Addressing IP & MAC
5. Installing Network Interface Cards
6. Configuring Network Interface Cards for TCP/IP & Troubleshooting
7. Internet & E – mail
8. Systems Management
9. Backup

Program Schedule