|
Electronic Database Management
Skill for Administrative Workflow
Course Objective
Electronic
File Management Potentials for Human Resources Managers and Administrative
Personnel in today’s complex information systems infrastructures
cannot be overemphasized.
Administrative or Human Resources Officers are relied upon
more than ever for timely and accurate information processing
capabilities but only personnel with adequate knowledge of modern
day information management techniques will be able to respond
adequately to the demand of their organizations. This course
is designed to train the personnel in administrative departments
of both private and public organizations in the modern and effective
way of doing their jobs
Course
Outline
Background
Information
.
Overview of Information Systems, Development in Information Technology
.
Electronic Filing Systems, Methods of Information Storage
.
Software and Hardware needs of Information System
Computer
Skill for Admin. / Human Resources Professionals
.
Overview of Computer Operations
.
Practical questions and answers sessions on Microsoft Windows
operations
.
Hands-on Sessions on Computer Skill for participants
Starting
up and Managing Databases
.
Introduction to Microsoft Access, Creating and Opening Databases
.
Understanding the Elements/Components of Database Windows
.
Table Creation and Property Settings
.
Hands-on Sessions/ Working Tutorials on Table Creation for all
participants
Managing
Data
.
Adding, Editing and Saving Records
.
Data Types and Validation Rules
.
Copying, Finding, Deleting & Sorting Records
Queries,
Forms, Reports and Simple Macros
.
Designing Forms, Sub forms and Queries
.
Using Queries for selective options
.
Using Forms to populate tables in a user friendly manner
.
Creating Reports and Macros
.
Types of Queries, Reports and Macros
.
Generating Reports from Tables, Queries and Forms
.
Using Macros to activate Forms, Dialog Boxes, etc.
.
Setting Printing Control Properties
.
Previewing and Printing Reports
Real
Life Application of Personnel Details
.
Billing, Assets Records, Maintenance & Corporate/ Individual
Relations/ Correspondences
.
Setting Up a Custom-made Personnel Detail Databases as real life
examples
Administrative
File Management Areas of Application
.
Employees File Management, Job Evaluation & Salary Administration
.
Manpower Planning, Performance Appraisal, etc. (From manual to
computer)
Note:
For the last two items, all participants are expected
to come with necessary manual
documents
which they may need to translate to computer operations using
Microsoft Access
Who
Should Attend?
The
above workshop is designed for any professional who may want to
use computer to achieve result.
Participants
of this workshop will also be able to understand computer operations
from the scratch
Dates
Duration
Venue
Cost (N)
Mar.19-23
5 Days Ultimate
Systems Solutions Training Center
38, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Apr. 23-27
5 Days
"
38,
500
May 21- 25 5 Days
Ultimate Systems Solutions Training Center
38, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Provision
Executive
Leather Bag, Lunch, Tea Break, Various Accounting Modules as stated
above on diskette, One Computer Per Participant, Group Photograph,
Workshop Materials
Note
Depending
on your choice, we can also run the above course for you in either
your office or your training center. But the number of participants
would not be less than 5.
| 