Advanced ECDL Databases 2013

This is a self study course which means you can study at home, workplace or wherever you choose at times that are convenient for you. You do not have any classes to attend.

The Advanced ECDL is a Level 3 qaulification (QCF). This is roughly equivalent to Level 6 in Scotland (SCQF). It is accredited by the British Computer Society (BCS).

Advanced ECDL Database (Module AM5) is a high-level certification programme that 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 and analyse high volumes of data, thus enabling the production of the quantity and quality of information that business today demands.

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 too.

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.

The materials are provided as web-pages for you to work through online. As you progress through the course materials you will find written 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.

HOW WILL I BE ASSESSED?

An assessment will be carried out in the college 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.

ENTRY REQUIREMENTS

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.

SPECIAL REQUIREMENTS

Please click here for a list of the technical requirements for this course. You must also have the following Microsoft Office 2013 software installed:

• Access 2013

Please note: Microsoft Works cannot be used or this course