Intermediate Access

North East Scotland College


Off campus


Microsoft Access Distance Learning units have been specifically designed to provide you with the knowledge and techniques needed for the successful creation and manipulation of an Access Database. The accompanying data files provided on disc are designed to help demonstrate the features as you work through the unit step-by-step.

This course covers the following topics:
Replacing, Cutting and Copying Text; Calculating Fields; Relationships; Lookup Fields; Default Values; Validation Rules; Sub-forms and Linking Forms; Combo and List Boxes; Tab Control;
Label and Chart Wizard; Importing and Exporting Data; Advanced Queries; Database Objects

Assessment for this course comprises of an end of course test to test your knowledge.

Entry Requirements

No formal entry requirements. You will require access to/use of the Microsoft Office Access Package.

Progression Routes

ECDL (European Computer Driving Licence) (SCQF Level 5)

Start Date




Study Method

Distance and Flexible learning

Course Length

6 months





Career Area

Computing and ICT

Career Sectors

Computer Skills

Related courses by level

Other Qualifications

Related job profiles

No related job profiles.

Computing General

IT Security

IT Support

Related courses by level

HNC and HND Other Qualifications

Programming and Development

Systems and Networks

Web and Multimedia