Advanced
Access

This advanced course will build on your knowledge and refine the techniques needed for use of an Access Database.

Overview

Why take this course?

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 are designed to help demonstrate the features as you work through the unit step-by-step.

What you will experience

The course will cover the following topics:

  • Creating Macros
  • Multiple Step Macros
  • Conditional Macros
  • Auto Exec Macros
  • Formatting Forms
  • Inserting Pictures & Charts
  • Adding Start-up Controls
  • Creating Data Access (Web) Pages
  • Email Database Objects
  • Database Utilities
  • Database Passwords
  • Database Analysis
  • Database Tools and Operations
Student at a computer

Key facts

Mode of study
Distance Learning
Method of study

This course will require you to manage your workload independently, with a basic level of tutor support.

Subject area

Entry requirements

There are no formal entry requirements for this course.

What you will need

You will require access to/use of the Microsoft Office Access Package.

What you need to know

Anything else?

This is a Distance Learning course which means you can study at home, in the workplace or wherever you choose at times that are convenient for you. You do not have any classes to attend. The materials for this course are provided as webpages for you to work through online. As you progress through the course materials you will find explanations of each feature, followed by practical exercises. You will be supported throughout the course by a specialist Distance Learning Tutor.

As you progress they will continue to make regular contact to offer support and guidance, usually by email but sometimes by phone, to ensure you are making good progress and to support your learning throughout. You must be able to study independently through the course materials.

Whilst studying with Business & Community Development, you will have access to the Library+ sites and the Digital Skills Space. You will also have technical and administrative support from Business & Community Development team.

Fee Waivers

Please note that fee waivers or funding may apply. Find out more about funding for part-time courses.

Next steps

Education

At North East Scotland College

On successful completion of this course, you can progress to the following course at North East Scotland College:

Employment

Availability

Pre-entry guidance is required prior to booking a place on this course. Please contact Brenda Bryce, Distance Learning Co-ordinator by email or on 01346 506014 in the first instance for more information. When submitting your distance learning application form, please ensure you attach the additional information sheet listing qualifications and previous knowledge with your application. You may be required to attend College for assessment. Please check if this is a requirement for your course.

Duration Fees Code
32 Hours over 6 Months £46.00
YBNAC
-O191A
Paper applications only

Paper applications

You must submit a paper application form for this course and return it to us completed and signed.

Completed forms should be returned to the following freepost address:

The Student Information & Admissions Manager
North East Scotland College
FREEPOST RTJJ-TXBA-AEZS
Aberdeen City Campus
Gallowgate
Aberdeen
Scotland
UK AB25 1BN

Should you have any problems with your application, please contact the Student Advice Centre:

Telephone: 01224 612330
Email: enquiry@nescol.ac.uk

If you take up a place on a College course, at the start of the course you will be asked to sign an enrolment form. In signing the form and/or taking up a place on a College course, you will enter into a contract with the College and be bound by the North East Scotland College Standard Terms and Conditions of Study. Copies of the Terms and Conditions are available for inspection on notice boards and at various locations throughout the College, at the College Reception, on the College website: www.nescol.ac.uk, or can be obtained on request from the Student Funding and Admissions Manager, North East Scotland College, Aberdeen City Campus, Gallowgate, Aberdeen AB25 1BN. Please note that courses are offered subject to (a) there being sufficient numbers of enrolments and (b) the availability of resources. The College reserves its right (i) not to run courses where the number of students is considered insufficient or where resources are unavailable and (ii) in certain circumstances, to refuse admission to an individual applicant.