Database Methods (Access) - 5N0783
The aim of this module is to equip the Learner with the knowledge, skills and competence to create and modify databases under supervision. The objectives are to facilitate the Learner to gain a clear understanding of why we use databases, what they are for, how to create a database from a design specification, how to manipulate, retrieve and modify information, and to explore some tasks for using a database, but not exclusively, in a business administration environment.
QQI Credits: 15
Outline a range of typical uses for databases.
Describe essential database concepts including database files, tables, records, fields, queries and reports.
Explain the purpose of query views such as design, datasheet, structured query language (SQL), pivot table, and pivot chart.
Open an existing database and perform routine operations including accessing records, entering and editing data, adding new records, searching, sorting, and managing fields.
Retrieve selected data from the table(s) in a database by designing and building simple queries which can be stored for re-use.
Construct a form to facilitate data entry into a database.
Create reports which can be used to present selected information from a database in a format suitable for e-mailing or printing.
Import data from external data sources, such as text files, spreadsheets, or existing database files.
Develop a database design including tables, keys, table relationships to meet a given design brief.
Create a database which includes tables, queries, forms and reports based on a given design brief.
Classroom-based, face-to-face 'Live Tutor instruction/in a classroom/and online class environment.
Blended learning (hybrid model where a portion of learning is classroom-based and a portion of which is online learning.
Tutor support available between classes (online, face-to-face, or by telephone).
QQI Level 4 Certificate, or equivalent life/work experience. A copy of your current Curriculum Vitae or certificate. It is expected that you will have a range of learning styles, strengths and needs related to the programme and have the capacity to take responsibility for your own learning within the managed classroom and online environment, provided by Lir Business Services & Training Centre.
Learners must reside in Ireland. This course is delivered through English. A competency test may be carried out for English language and literacy and/or computer skills to ensure that you have the skills necessary to complete the programme.
Learners must reside in Ireland. The following English language proficiency tests and results are acceptable :
IELTS Indicator Test The minimum score is 6 unless otherwise stated.
TOEFL iBT Special Home Edition The minimum score is 92 unless otherwise stated.
Duolingo English Test The minimum score required is 95 unless stated otherwise.
Exam English If you are unsure of your current level, you can take a free test on sites such as this one.
If you are unsure contact Lir Reception (044) 9342754 to speak to a qualified person who will be able to assist you.
IT/Computer Skills: sufficient working knowlege of computers. Learner must have access to a PC, laptop or mobile device with internet access, Windows 8 or later or a Mac with OSX 10.5 or later, a browser with the latest version of Microsoft Edge, Chrome, Firefox or Safari, Adobe Reader to view PDFs. Your device must have a working camera and audio. PC must be capable of playing video and audio files. We provide you with access to Microsoft 365 Office applications (Word, Excel, Powerpoint, Outlook, Teams).
Blended Learning: Learners must be self-motivated and be able to take responsibility for their own self-directed learning, outside the 'Live' Tutor online classes as they complete their blended learning course.
Reasonable Accommodation: Learners with a disability, medical condition or learning difficulty: In line with the Equal Status Acts 2000 to 2015 - Lir provides reasonable accommodation to meet the needs of our learners to ensure fairness and equality with others on the course.
Following successful completion, you will receive a QQI Level 5 component certificate in Database Methods (5N0783) from QQI.
Quality and Qualifications Ireland (QQI) is the national awarding body for further education and training in Ireland. Lir Business Services & Training Centre Ltd is registered with QQI, as a Private Training Provider, to offer programmes leading to QQI awards on the National Framework off Qualifications in Ireland (N.F.Q.)
Learner Progression: Learners who successfully complete this module may use the associated credits towards a relevant Major Award.
Grading: Pass 50% - 64%, Merit 65% - 79%, Distinction 80% - 100%
See Lir Course Schedule
A Blended and Online Course with 'Live' Tutor classes, optional Virtual Office Hours and Tutorials. 2 x Workshops over 5 weeks or 8 x Evening Classes plus self-directed learning with online support.
This Programme comprises of 1 module. The duration of this module is typically 150 hours. This is a combination of 50 hours of Directed Learning and 100 hours of Self-directed learning. The 50 hours of Directed Learning takes place in Classroom Attendance and 'Live' Tutor Online Classes. Self-directed Learning is learner-led, and it includes self-directed study, through Lir eLearning Hub. This will entail preparation and reflection time on your part. There are Virtual Office Hours throughout the week also to give you the opportunity of meeting your Tutor online, if you have any queries.
Upon successful completion of a Major award, learners can progress to an award on the next level on the NFQ. Alternatively, the Higher Education Links Scheme (HELS) gives learners the opportunity to use their QQI Level 5/6 Major Award to apply through the CAO for a place in the first year of a higher education programme. In some instances, progression is on the basis of specific Level 5 or 6 Major Awards, Learners should check with the higher education institution prior to commencement. Components (Minor Awards), or achievement of less than 120 credits, will not suffice for progression under the HELS.
Course fee: Phone Lir Reception (044) 934 2754 for a quote.. Payment: 1) in full, or 2) flexi-payments, 3) funding, 4) in-company - separate quote You may qualify for funding by contacting your local Intreo/DSP Office.
22 July 2022 at 09:40:01