7 John F Kennedy  Parade, Sligo, Ireland Tel: 071-9143656      Fax: 071-9141629    Email: contact@cbtraining.ie

Advanced ECDL Database This module requires the candidate to use the database to organise, extract, view and report on data using advanced data management skills. The candidate will understand the variery of ways that data can be related and organised, and to import, export and link data. Selection of Topics Covered: Field validation, input masks and lookup Many-to-many table relationships and referential integrity Inner, outer and self joins Queries that append, update and delete table records Queries that use functions, crosstabs and wildcards Queries that use arithmetic and logical expressions Showing duplicates, unmatched values, and highest and lowest values Parameter queries that accept data input from a prompt Forms with bound and unbound controls, formulas and expressions Macros and reports Data import and export from/to a range of file formats Back to Courses