INTRODUCTION
Most organizations maintain and manage large amounts of
information. One of the most efficient and powerful ways of managing data is by
using relational databases. Information can be stored, linked, and managed
using a single relational database application and its associated tools.
Microsoft Access is a very popular program used worldwide to build and run
databases. Databases created with MS Access can also be viewed and edited
online by uploading them to SharePoint. Microsoft implements some safety
precautions when you work with online files, and this course will show you how
to activate your content after you download it. This course will also
review keyboard shortcuts which help you work faster by relying more on the
keyboard. You do not need any prior experience working with Access to
undertake this course, but if you are familiar with previous versions, then
this course will help you quickly make the transition to the upgraded version,
Microsoft Office 2013 that would be used in this course.
COURSE OBJECTIVES
At the end of course participants
should be able to:
DURATION
5
Days
WHO SHOULD ATTEND
The course targets individuals who wish to
establish a foundational understanding of Microsoft Office Access, including
the skills necessary to create a new database, construct data tables, design
forms and reports and create queries.
COURSE CONTENT
MODULE 1
Getting started
Databases and tables
Fields and records
Basic queries
Using forms
Working with reports
MODULE 2
Relational databases
Related tables
Complex queries
Advanced form design
Unit 5: Reports and printing
Charts
MODULE 3
Querying with SQL
Advanced queries
Macros
Advanced macros
Importing, exporting, and linking
Database management
Setting options and properties
GENERAL
NOTES
·
This course is delivered by our seasoned trainers who have
vast experience as expert professionals in the respective fields of practice.
The course is taught through a mix of practical activities, theory, group works
and case studies.
·
Training manuals and additional reference materials are
provided to the participants.
·
Upon successful completion of this course, participants will
be issued with a certificate.
·
We can also do this as tailor-made course to meet
organization-wide needs. Contact us to find out more: training@skillsforafrica.org
· The training will be conducted at SKILLS FOR AFRICA TRAINING INSTITUTE IN NAIROBI
KENYA.
· The training fee covers
tuition fees, training materials, lunch and training venue. Accommodation and
airport transfer are arranged for our participants upon request.
·
Payment should be sent to our bank account before start of
training and proof of payment sent to: training@skillsforafrica.org
Dates | Fees | Location | Apply |
---|---|---|---|
14/10/2024 - 18/10/2024 | $2950 | Kigali | Physical Class Online Class |
11/11/2024 - 15/11/2024 | $1500 | Mombasa | Physical Class Online Class |
09/12/2024 - 13/12/2024 | $1500 | Nairobi | Physical Class Online Class |