|
ECDL Advanced AM5 Courseware
Syllabus 2.0
The European Computer Driving Licence
 DATABASE CONCEPTS
DATABASE DEVELOPMENT AND USE
- Understanding different types of database models such as hierarchical, relational and object-oriented.
- The life cycle stages of a database: logical design, database creation, data entry, data maintenance and information retrieval.
- Common business applications of databases such as 'dynamic websites'
- Common business applications of databases such as 'customer relationship management systems'
- Common business applications of databases such as 'enterprise resource planning systems'
- Common business applications of databases such as 'website content management systems'
- Knowing the term SQL (structured query language) and understand its main use in querying database content.
TABLES AND RELATIONSHIPS
FIELDS
- Creating, modifying and deleting a lookup in a field.
- Creating, modifying and deleting an input mask in a field.
- Setting data entry for a field: required, not required.
RELATIONSHIPS AND JOINS
- Creating, modifying and deleting a one-to-one relationship between tables.
- Creating, modifying and deleting a one-to-many relationship between tables.
- Creating and modifying a many-to-many relationship using a junction table.
- Applying referential integrity between tables.
- Applying automatic update of related fields.
- Applying automatic deletion of related records.
- Applying and modifying an inner join and an outer join.
- Creating and modifying a subtract join.
- Applying a self join.
QUERIES
QUERY TYPES
- Creating and running a query to update data in a table.
- Creating and running a query to append records to a table.
- Creating and running a query to delete records in a table.
- Creating and running a query to save selected data as a new table.
- Creating and running a crosstab query.
- Creating and running a query to show duplicated records within a table.
- Creating and running a query to show unmatched records in related tables.
REFINING A QUERY
- Creating, modifying and running a one variable parameter query.
- Creating, modifying and running a two variable parameter query.
- Using wildcards in a query: [ ], !, -, #.
- Showing highest, lowest range of values in a query.
- Creating and naming a calculated field that performs arithmetic operations.
- Grouping information in a query using functions including sum, count, average, max & min.
FORMS
CONTROLS
- Creating, modifying and deleting bound controls: text box, combo box, list box, check box, option groups.
- Applying and removing bound control properties like: limit to list, distinct values.
- Creating, modifying and deleting unbound controls containing arithmetic, logical expressions.
- Modifying sequential tab order of controls on a form.
- Creating and deleting a linked subform.
REPORTS
CONTROLS
- Formatting arithmetic calculation controls in a report: percentage, currency, to a specific number of decimal places.
- Applying a running sum for a group, over all.
- Concatenating fields in a report.
PRESENTATION
- Inserting and deleting a data field in group, page, report headers and footers.
- Sorting and grouping records in a report by field(s).
- Force page breaks for groups in a report.
- Creating and deleting a linked subreport.
ENHANCING PRODUCTIVITY
LINKING AND IMPORTING
- Linking external data to a database: spreadsheet, text (.txt, .csv), existing database files.
- Importing spreadsheet, text (.txt, .csv), XML, existing database files into a database.
AUTOMATION
- Creating 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.
- Assigning a macro to a command button, object or control.
|
