BCS Advanced ECDL Database and Presentation

BCS Advanced ECDL - Database & Presentation

Code: 70013

Department: ICT

Short Description: ECDL advanced Databases and Presentation will allow someone who used the applications regularly to use more advanced tools.

Entry Requirements: ECDL

Content: Databases
Table Design Understand the use of various data types, create input masks and validation rules, set 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 and create new tables based on query data. Use functions and logical expressions in a query. Use crosstab 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.

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 and run macros. Assign macros to form/report controls.

Data Management Import and export data. Link data to an external database.

Presentations
Audience & Environment Understand how audience demography and knowledge of subject requires the need to deliver the message differently.

Presentation Awareness of issues with fonts and colours, such as colour blindness.

Delivery Understand important design concepts associated with presentation delivery such as, logical sequencing, time and attention span

Design Insert pictures and images, change position or layout of pictures. Omit background graphics from a slide. Apply 3D effects, shadows, background fill colours, textures and patterns. Crop, resize, rotate, flip an image.

Charts and Graphs Create and change a chart or graph. Create and edit a flowchart.

Multimedia Insert sounds and movies with entry animation.
Slide Show Setup Insert navigation to slides, presentations and URL's. Apply and edit timings. Create a customised slide show.

Link Data Link, modify and update text or data from a document or spreadsheet.

Macros Create and run a macro. Assign a macro to the toolbar.