Advanced ECDL: Database

The following is the Syllabus for Module AM5 Database Advanced Level which provides the basis for the practice-based test in this module domain. The Syllabus for module AM5 is over and above the skills sets and underpinning the knowledge contained within the ECDL Module 5 Database Version 4.0 Syllabus or earlier. The advanced level designation for Module AM5 anticipates that the candidate has already mastered the Skill Sets and acquired the knowledge outlined in Module 5 of ECDL Syllabus Version 4.0 or earlier

Know that different types of database models exist like: hierarchical, relational, object-oriented.
Know the life cycle stages of a database: logical design, database creation, data entry, data maintenance, information retrieval.
Recognize common business applications of databases like: dynamic website, customer relationship management systems, enterprise resource planning systems, website content management systems. AM5.1.1.4
Know the term SQL (structured query language) and understand its main use in querying database content.

Create, modify, delete a lookup in a field/column.
Create, modify, delete an input mask in a field/column.
Set data entry for a field/column: required, not required.
Create, modify, delete a one-to-one, one-to-many relationship between tables.
Create, modify a many-to-many relationship using a junction table.
Apply referential integrity between tables.
Apply automatic update of related fields.
Apply automatic deletion of related records.
Apply, modify an inner join, outer join.
Create, modify a subtract join.
Apply a self join.

Create, run a query to update data in a table.
Create, run a query to append records to a table.
Create, run a query to delete records in a table.
Create, run a query to save selected data as a new table.
Create, run a crosstab query.
Create, run a query to show duplicated records within a table.
Create, run a query to show unmatched records in related tables.
Create, modify, run a one, two variable parameter query.
Use wildcards in a query: [ ], !, -, #.
Show highest, lowest range of values in a query.
Create and name a calculated field that performs arithmetic operations
Group information in a query using functions: sum, count, average, max, min.

Create, modify, delete bound controls: text box, combo box, list box, check box, option groups.
Apply, remove bound control properties like: limit to list, distinct values.
Create, modify, delete unbound controls containing arithmetic, logical expressions.
Modify sequential tab order of controls on a form.
Create, delete a linked subform.

Format arithmetic calculation controls in a report: percentage, currency, to a specific number of decimal places.
Apply a running sum for a group, over all.
Concatenate fields in a report.
Insert, delete a data field in group, page, report headers and footers.
Sort, group records in a report by field(s).
Force page breaks for groups in a report.
Create, delete a linked subreport

Link external data to a database: spreadsheet, text (.txt, .csv), existing database files.
Import spreadsheet, text (.txt, .csv), XML, existing database files into a database.
Create a simple macro like: close an object and open another object, open and maximize an object, open and minimize an object, print and close an object.
Assign/attach a macro to a command button, object, control.