Do you regularly use a database application and need to know how to use a database system and be able to organize, view and extract data?
If so, ECDL Advanced Databases will give you the knowledge and skills you need. The syllabus covers the following:
- Table Design - using various data types, create input masks, validation rules, mandatory fields.
- Data Relationships - understand and create data relationships, apply inner, outer and self joins, apply and use referential integrity.
- Query Design - create queries to update, append and delete data, create new tables based on query data, group data queries, use functions and logical expressions in a query, show duplicate entries and highest/lowest values, use cross-tab and parameter queries.
- Form Design - create bound and unbound controls, combo, list and check boxes and option groups. Set arithmetic and logical expression controls, set sequential order of controls on a form, create and modify sub-forms.
- Report Design - create arithmetic, logical and percentage controls on a report, use formulas such as sum, max and count, create running summaries and data headings.
- Macros - create, run macros, assign macros to form/report controls.
- Data Management - import, export and link data.
See the full syllabus here. Try a sample test from the British Computer Society, or purchase an learning pack from the Learning Team, Uxbridge Library for only £20 (includes a multitude of exercises & sample tests but not exam registration).
AM3 - Word Processing | AM4 - Spreadsheets | AM5 - Databases | AM6 - Presentations
