SCQF Level 6
This advanced course will strengthen your skills and understanding when it comes to Databases 2013.
Why take this course?
Database applications are a powerful resource, managing and analysing high volumes of data to produce the quantity and quality of information that business today demands. This high-level certification programme enables candidates to use the many advanced tools available in database applications to better manage and organise structured information. Successful completion of this module will enable candidates to maximise database functions in order to manage/analyse high volumes of data, thus enabling the production of the quantity and quality of information demanded in business today. It has been specifically designed to:
- Allow users to become more confident, efficient and effective in using a database application
- Prove mastery of the application
- Enable users to retrieve and produce higher quality management information
- Improve user's productivity
This Advanced ECDL course is a Level 3 qualification (QCF) - roughly equivalent to SCQF Level 6 in Scotland - and is accredited by the British Computer Society (BCS). Please note that although there are four Advanced ECDL Modules and these can enrolled on, completed and certified independently of each other, you only need to complete all four modules if you choose to.
What you will experience
This course is highly comprehensive, and has been developed with input from computer users, subject matter experts and practising computer professionals from all over the world - this ensures relevance and accuracy of module content. Individuals with Advanced ECDL Database certified skills will be able to:
- Understand key concepts of database development and usage
- Create a relational database using advanced table creation features and complex relationships between tables
- Design and use queries to create a table, update, delete and append data.
- Refine queries using wildcards, parameters and calculations
- Use controls and subforms to enhance forms and improve functionality
- Create report controls to perform calculations
- Create subreports and enhance report presentation
- Enhance productivity by working with macros and use linking and importing features to integrate data
Upon completion of this course you should be able to maximise the Microsoft Access package using skills and knowledge that will set you apart in today's competitive job market.
Prospective students should ideally have the ECDL certification and/or previous experience using computers and common software applications. It is essential that you have previous experience in using a computer, the Windows interface and Windows terminology.
What you will need
You must have the following Microsoft Office 2013 software installed: Access 2013. Please note that Microsoft Works cannot be used for this course.
What you need to know
An assessment will be carried out in the College's Assessment Centre when you have completed the course work. The cost of the Advanced Test is £60 payable at the time of booking. Payment can be made in cash at the Assessment Centre Reception in LG10, by cheque made payable to North East Scotland College or by Credit or Debit Card by telephoning the Assessment Centre on 01224 612237.
This is a Self Study 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. Your tutor will contact you (via your College email account) within 7-10 working days of receiving your welcome letter and materials.
As you progress they will continue to make regular contact to offer support and guidance, usually by e-mail but sometimes by phone, to ensure you are making good progress and to support your learning throughout. Please note that you must be able to study independently through the course materials.
This course can be accessed through Blackboard which is North East Scotland College's Virtual Learning Environment (VLE). Through Blackboard you will be able to access your learning materials, information and communicate with other students. A short guide to Blackboard has been provided for your use.
Whilst studying with Business & Community Development, you will have access to the Library+ sites and the IT Centre. You will also have technical and administrative support from Business & Community Development team.
Please note that it is a requirement that all email communication between staff and students is made using College email accounts. This ensures that the College complies with Data Protection legislation and that information is accessed only by authorised users.
For more information about job opportunities, salaries and employment rates in this industry, visit the Career Coach website.
|60 Hours over 10 Months||£139.00||
|Paper applications only|
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
Aberdeen City Campus
UK AB25 1BN
Should you have any problems with your application, please contact the Information & Booking Centre:
Telephone: 01224 612330
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.
For distance learning courses, the course fees for non-Scottish residents may differ from that advertised on the website and in the course guide. Therefore, all course fees should be confirmed with the College at the time of booking.