Video Blogging with YouTube

About this course

This classroom-taught module develops intermediate Microsoft Access skills towards the advanced ECDL qualification. Learners work with relational database structures, complex table relationships and queries involving calculations, parameters and wildcards. The course also covers enhanced forms and reports, including controls, subforms, calculations and subreports, alongside macros and methods for linking or importing data. It concludes with the relevant ECDL test.

What you'll learn

• Create relational databases using advanced table structures and relationships
• Design queries that create, update, delete and append data
• Refine queries using wildcards, parameters and calculations
• Enhance forms and reports with controls, subforms, calculations and subreports
• Use macros, linking and importing features to improve database productivity and integration

Is this course right for you?

The source describes this as an advanced, classroom-taught module rather than a beginners’ course. It is intended for learners who already have intermediate Microsoft Access knowledge and a good level of English and maths, equivalent to Level 2.

• Existing intermediate Microsoft Access skills are expected
• A good Level 2-equivalent standard of English and maths is stated
• The course includes preparation for an ECDL test