BCS Advanced ECDL Database and Presentation
Vocational qualification
In Holywood
Price on request
Description
-
Type
Vocational qualification
-
Location
Holywood (Northern Ireland)
ECDL advanced Databases and Presentation will allow someone who used the applications regularly to use more advanced tools.
Facilities
Location
Start date
Holywood
(County Down)
See map
Old Holywood Rd, BT18 9QH
Start date
On request
Reviews
Have you taken this course?
Course programme
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.
BCS Advanced ECDL Database and Presentation
Price on request