Welcome to the world of Database Methods - 5N0783! Are you ready to embark on a journey into the heart of data management and unlock the secrets of powerful databases? In this course, we will dive headfirst into essential database concepts, laying the foundation for your database prowess. We'll explore the fascinating realms of database files, tables, records, and fields, gaining insight into the very building blocks of organised information. But that's just the beginning! Hold on tight as we unravel the mysteries of queries and reports, unleashing their true potential.
You'll discover the purpose of various query views like design, datasheet, structured query language (SQL), pivot tables, and pivot charts - empowering you to extract and visualise data like never before! Not stopping there, we'll take the plunge into practical hands-on operations. You'll open existing databases and perform routine tasks with ease, accessing records, entering and editing data, and adding new records, as if you were a seasoned database expert.
But that's not all - we'll equip you with the tools to become skilled at data retrieval. Building simple queries will become second nature, and you'll learn to store them for future use, making data exploration a breeze.
And there's more! Ever wanted to construct a powerful data entry form? By the end of this course, you'll be creating forms that simplify data input, streamlining the entire database experience.
But wait, there's even more excitement in store! Brace yourself as we craft captivating reports, presenting selected information from the database in a format perfect for emailing or printing. Your data will come to life, conveying meaningful insights like never before. We'll push the boundaries further, empowering you to import data from external sources like text files, spreadsheets, or even existing databases. Your data playground will expand, but we're not done yet.
As we delve into database design, you'll build tables, keys, and establish essential table relationships to meet specific design briefs. You'll feel the thrill of creating a fully functional database from scratch, complete with tables, queries, forms, and reports! Throughout this adventure with Lir, we'll equip you with the knowledge and resources to tackle database challenges. So, whether you're a beginner or know a little, this course will take your data skills further.
To summarise, the aim of this module is to equip you with the knowledge, skills and competence to create and modify databases under supervision. The objectives are to facilitate you 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. So book now.
Learning at your own pace doesn’t mean learning alone. At Lir, our Fully Online, Self-Paced course is designed for busy learners who want the freedom to study when it suits them – while still having access to real guidance, structure, and human support.
Studies show that learners in online environments with flexible pacing perform just as well as in-person learners – when clear structure and tutor interaction are present. (Source: Bernard et al., 2009; Moore et al., 2011, Journal of Distance Education)
Course Content
💻 Unit 1 – Getting Started with Microsoft Access
Discover the essentials of Access and set the foundation for your database journey.
📂 Unit 2 – Building Your First Database
Learn how to create, save, and open databases with confidence.
🗂️ Unit 3 – Designing Tables and Fields
Master the building blocks of databases by creating structured tables and fields.
🔍 Unit 4 – Unlocking Data with Queries
Explore how to ask powerful questions and extract meaningful insights from data.
🔗 Unit 5 – Combining Tables and Queries
Take your skills further by linking tables and running more advanced queries.
📝 Unit 6 – Creating User-Friendly Forms
Design interactive forms that make data entry simple and efficient.
📊 Unit 7 – Bringing Data to Life with Reports
Transform raw data into professional, easy-to-read reports.
📘 Unit 8 – Exam Preparation Made Simple
Review, practice, and prepare effectively for your assessment.
🚀 Unit 9 – Your Final Database Project
Put your knowledge into action with a real-world project that showcases your skills.
We check in to see how you're progressing and offer support or feedback when needed.
Duration: 8 - 10 weeks
Submit tasks or questions anytime and receive personalised responses within 48 hours.
Get help between classes via email or message. We’re always here when you need us.
Learn through video lessons, real-world scenarios, and guided activities – all designed to keep you engaged.
In order to commence this programme, you must have either successfully completed a programme at a level 5 QQI Certificate/ equivalent qualifications. If you do not have the required qualification you may also be eligible if you can demonstrate that you have the necessary skills to complete this module. If you have a Level 5 Certification and a computer skills qualification at Level 5 in Word Processing and Spreadsheets, and/or life/work experience at that level or higher.
If you have a disability, medical condition or learning difficulty: In line with the Equal Status Acts 2000 to 2015 - we provide reasonable accommodation to meet the needs of our learners to ensure fairness and equality with others. See Learner Supports for further information.
IT/Computer Skills - sufficient working knowledge of computers. You must have access to a PC (desktop), 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. Camera: Your device must have a working camera and audio. PC must be capable of playing video and audio files. Software: We can provide you with access to Microsoft 365 Office applications (Word, Excel, Powerpoint, Outlook, Teams), Zoom and a Bookkeeping Software Licence.
Blended Learning: You must be self-motivated and be able to take responsibility for your own self-directed learning, outside the 'Live' Tutor online classes as you complete your blended learning course, or in the Fully Online Self-paced modules. Be disciplined in self-directed learning in line with practical preparation, study, and reflection time where appropriate. You have to set time aside. You will be expected to: fluently read, draft, prepare and understand material which is relevant and reflects a broad personal knowledge. fluently read, draft, prepare and understand quantitative data. problem-solving within a group or a number of groups and independently. 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.
You must reside in Ireland and have a valid PPS Number.
The interview process ascertains existing levels of knowledge, skills competence and English language proficiency. A copy of your current Curriculum Vitae or certificate will be required and Photo ID. The Induction will be carried out using Zoom, so you must have a working camera, a microphone for the session.
Learners will also require a good command of the English language and have a recognised English language qualification. An assessment of English writing and comprehension may be given to ensure equivalency with English language speaking and learning to assess a minimum standard level. Leaving Certificate (H7/06 in English).
English Language: This course is completed using the English language.
QQI 5N1642 English as a Second Language (merit or distinction).
QQI 5N0690 Communications Level 5 (merit or distinction).
CEFR - Common European Framework for Languages (level B2 or higher). 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.
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. https://www.ieltsindicator.com International English Language Testing System - Academic The minimum score is 6 unless otherwise stated. https://www.ets.org/s/cv/toefl/at-home/ TOEFL iBT Special Home Edition. Test of English as a Foreign Language. Internet-based test (minimum score is 100 out of 120. Reading and Writing not less than 22. https://englishtest.duolingo.com/applicants. The minimum score required is 95 unless stated otherwise.
If you are unsure of your current level, you can take a free test on a number of sites, like http://www.examenglish.com/leveltest/index.php, or contact Lir Reception (044) 9342754 to speak to a qualified person who can assist you. If you are unsure contact Lir Reception (044) 9342754 to speak to a Training Consultant who will be able to assist you.
First of all, contact Lir Reception (044) 9342754 before you book. This way you will get an opportunity to speak with a Training Professional to discuss your options and to make sure that this module is the best one for you. To register, fill out our Lir Registration Form. You will have been given an Access Code for this form. Once registered we set you up with a Lir Microsoft email address which gives you access to Microsoft 365 software, at no extra cost to you. From there we send you access details on how to access your course so you can avail of the 'Live' Tutor scheduled Online Classes, Learner Supports and give you access to the Lir eLearning Hub.
Director of Training/Tutor
frances@lirbusinesscentre.com
Training Co-Ordinator
joan@lirbusinesscentre.com
Tutor/Facilitator
deirdre@lirbusinesscentre.com
Office Assistant (2023)
(2024)
(2025)
€300