Advanced AccessThe ECDL Advanced (ECDL Advanced, ICDL Advanced) Databases unit is 1 of 5 that is covered within our Teach Yourself Advanced Office manuals, which are designed to help self-study learners gain globally recognised (ECDL Advanced, ICDL Advanced, ICDL Expert and ECDL Expert) qualifications. This unit covers complex tasks within a Database (Microsoft Access) application, including creating relationships between tables, designing and using queries to create a table, using controls and sub-forms, creating reports to perform calculations and using macros (unit prices from just £6.99, examinations not included). All our manuals cover Microsoft Office 2007, 2010, 2013 and 2016 versions.

Entry Requirements

Although there are no specific entry requirements for ECDL level 3 courses, it is advisable that self-study learners have some prior knowledge of the Microsoft Access application in completing the ECDL Advanced (European Computer Driving Licence) and ICDL Advanced (International Computer Driving Licence) level 3 Access course.

 

Course Contents

Questions, answers and work-files covering the ECDL Advanced Databases unit/module:

 

  • Underpinning Knowledge
  • Formatting Fields
  • Query PROFIT Formula
  • Query DATE Formula
  • Importing data
  • Sort Data
  • Input Masks
  • Exporting Data
  • Delete Queries
  • Command Buttons
  • Print Specific Records
  • DATE & TIME Function
  • Print Screen
  • Report Fields
  • Query Criteria
  • Macros
  • Forms
  • Query Wizard
  • Query Formulas
  • Form Styles
  • Delete Data
  • Duplicate Records Query
  • Wildcards
  • Crosstab Query
  • Show Highest Range of Values in a Query
  • Add Subform
  • Delete Subreport
  • Add Control Properties
  • Query SUM Function
  • Report Calculations
  • Lookup Query (2013 versions onwards)
  • Update Query (2013 versions onwards)
  • Append Query (2013 versions onwards)
  • Make Table Query (2013 versions onwards)
  • Form Controls (2013 versions onwards)
  • Report Fields (2013 versions onwards)
  • Report Page Breaks (2013 versions onwards)
  • Relationships (2013 versions onwards)
  • Form Tab Controls (2013 versions onwards)
  • Form Properties (2013 versions onwards)

 

Additional

 

  • Two full practice tests
  • Marking schemes
  • Exam tips
  • Shortcut tips

 

Examinations

There are over 2,000 ECDL, ITQ local testing centres throughout the UK and over 10,000 ICDL testing centre worldwide.  The ECDL Advanced and ICDL Advanced examinations have no registration fee but examinations cost £70 per exam (prices may vary), please contact your local ECDL/ICDL testing centre for further information.

 

Hours of Study

There is no set study time limit for ECDL Advanced (level 3) and ICDL Advanced Database courses but learners are advised to allow approximately 45 hours depending on their abilities.

 

Study Period

There is no specific time limit set by the ECDL, ICDL awarding bodies to complete the ECDL Advanced and ICDL Advanced modules/units.

 

QCF Level

ECDL Advanced (level 3) qualifications are recognised by the "Qualifications and Credit Framework" and are equivalents to UK ‘A-Level’ standards.

 

Attainable Certifications

There are several recognised certifications that can be achieved or worked towards via the Advanced Database (Access) unit/module, these include:

 

  • ECDL Advanced Databases
  • ICDL Advanced Databases
  • ECDL Expert (worked towards)
  • ICDL Expert (worked towards)
  • ITQ Level 3 Certificate in IT User Skills (worked towards)