Seminar On Microsoft Access
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.
At the end of course participants
should be able to:
data into appropriate tables to ensure data dependency and minimize
queries to analyse and summarize data
and revise macros
databases using Microsoft Access tools
and work with online databases.
and publish web databases.
- Save a
changed database to the web.
keyboard shortcuts and access keys.
to work with security protocols.
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.
the Access environment
Databases and tables
and designing databases
Fields and records
the design of a table
and editing records
- Setting field properties
- Working with input masks
- Setting validation rules
and using queries
query results and queries
operations in queries
and filtering records
Working with reports
and printing reports
tables in queries
and grouping values
Advanced form design
Unit 5: Reports and printing
headers and footers
- Modifying PivotTables
- PivotTable forms
- PivotTables and PivotCharts
Querying with SQL
SQL queries to controls
running, and modifying macros
macros to the events of database objects
macros to provide user interaction
macros that require user input
the AutoKeys and AutoExec macros
macros for data transfer
Importing, exporting, and linking
with XML documents
with Windows SharePoint Services
Setting options and properties
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: email@example.com
· The training will be conducted at SKILLS FOR AFRICA TRAINING INSTITUTE IN NAIROBI
· 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: firstname.lastname@example.org