Certificate in Introduction to Spreadsheets & Databases


OverviewCourse OutlineFees & PaymentHow to Apply

Who Should Attend?


This Certificate in Introduction to Spreadsheets and Databases will suit students wanting to expand their knowledge and understanding of MS Excel and MS Access using working models to develop a hands on experience of the applications.

Course Duration

This 10 week professional development course will be delivered live online via Zoom one evening per week for 2.5 hours from 6.30-9.00pm starting the week of 22nd June 2020.

Over the 10 classes the course will cover:

Course Modules

Week 1
Introduction – MS Excel navigating the screen and interface. Basic formulae
Week 2
More advanced functions, building 2 x models Phone spend schedule / Invoice
Week 3
Extending functions and looking at grouping sheets in a work book. Print area and design / layout techniques
Week 4
Macros part 1 – an introduction and basic development tools
Week 5
Macros part 2 – more advanced developer tools and basic VBA
Week 6
Introduction MS Access and general databases
Week 7
Tables, data entry and relationships
Week 8
Queries and an introduction to the processing potential of Access
Week 9
Forms: Introduction, design and implementation of effective database forms
Week 10
Reporting: Design and implementation of the output of Databases

1 x Excel model and 1 x Access model CA projects both for completion at the end of the 8 weeks.

Accreditation

This course is provided by Independent College Dublin and is primarily based on modules delivered in the BA Accounting and Finance degree course that is approved by QQI.


Learn from our Leading Practitioner


Gerard Keating FCCA MBA is an experienced Chartered Certified Accountant with Financial and General Management Experience in a number of industry sectors including Private Education, Advertising, Marketing, Media, Technology, Luxury Ground Transportation, Construction, Oil and NGOs.He is a part-time lecturer in three private colleges in Dublin, teaching QQI Level 7 and Level 8 students as well as evening Diploma courses.

The fees for this course are €995 and will include a 3 month subscription to Microsoft Office 365. You will awarded with a professional certificate upon complication.

Fill out the form on the link provided below

<Apply Online Click Here

You can also contact the Admissions Office:
E-mail: profcourses@independentcolleges.ie