You
will learn
How to
create queries, databases, forms
and reports.
Implement,
extract and report on data.
How to use
formulae and relationships.
====================
Audience
Holders of
ECDL or MOS Comprehensive level
Certification.
Anyone
wishing to enhance their
employment opportunities.
====================
Duration
7 weeks X 3
hours
====================
Cost
|
|
Overview
The
Microsoft Office Specialist course in Access is
a means of indicating that you can productively
use MS Access.
Participants will learn how to create their own
databases to record their data.
83% of employees say that Microsoft Office
Specialist certification provides an advantage
to employees in hiring, promotion and
advancement decisions.
What
is covered
Structuring
Databases - creating and modifying
tables, field types and properties, one-to-many
relationships, referential integrity, creating
queries, forms and reports.
Entering Data
- enter, edit and delete records, find and move
among records, import data to Access.
Organising Data
- calculated fields and aggregate functions,
modify form, and report layout, format
datasheets, sort and filter records.
Managing
Databases - object
dependencies, printing database objects and
data, export data from Access, backing up your
database, compacting and repairing databases.
CERTIFICATION
Microsoft Office Specialist at Core/Specialist
Level.
Objectives
To ensure
all participants gain the skills
necessary to use their personal
Computers at an optimum level.
|
