ECDL / ICDL Advanced - Databases

Version 2.0 Using Access

Courseware Training Materials

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.

ECDL Advanced version 2.0 | Module 3 |  | Module 4 | Module 5 | Module 6 |

ECDL | European Computer Driving Licence
ICDL | International Computer Driving Licence