The Course

This course is designed to introduce you to the key skills in Access, whether you intend it as a stand alone qualification or as part of the MOS or ECDL.. It will be of practical benefit to anyone who has to use Access on a regular basis. 

Each lesson begins with a set of clearly stated objectives and an explaination of its place in the overall programme of study.  There are 22 lessons and 3 tutor-marked assignments.  In addition, there are numerous self-assessment tests and activities to measure your progress.  We also include a CD Rom in the course materials which contains suggested answers, dummy files and other resources.

The Syllabus

This course is Certified by Microsoft as part of the Microsoft Office Specialist qualification.  There are three other modules which complete MOS:

Excel

Powerpoint

Word

OR

This course can also be certified by ECDL as part of the European Computer Driving Licence qualification using syllabus Version 4.0.  There are six other modules comprising the ECDL:

• Concepts of Information Technology
• Using a computer and managing files
• Spreadsheets (Excel)
• Presentation (Powerpoint)
• Word Processing (Word)
• Information and communication (E-mail and the Internet)

Key Topics

The course covers all the key skills requires by the MOS/ECDL exams, including:

• Creating tables and manipulating data
• Using Autoform and table columns
• Designing and working with Relational databases
• Creating Queries, advanced queries, Forms and Reports
• Using Masks and filters

Assessment

Examinations can be arranged through MOS or ECDL's websites.  They can be taken at any time of year by students sitting at a keyboard in a MOUS/ECDL registered centre.  Students are responsible for making their own examination entries.  The fee varies a little from one centre to another.

Duration

We recommend that each module should take about 50 hours of study over three months to complete.

Special Requirements.

No prior computer skills are needed but students must have access to a computer with Access 2000 or Office 2000 or XP.