Database Methods 5N0783

This is a standalone QQI Certified module, or part of the 5M2468 Business Administration or 5M1997 Office Administration Major Award.

Course Introduction

 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.

Course Content

Unit 1 - Introduction to Microsoft Access Database

Unit 2 - Create, Save and Open a Database

Unit 3 - Create Tables and Fields

Unit 4 - Creating Queries

Unit 5 - Creating Tables and Queries 

Unit 6 - Creating Forms

Unit 7 - Creating Reports

Unit 8 - Exam Preparation

Unit 9 - Database Project

How do I book my course?

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.

Frances

Director of Training/Tutor
frances@lirbusinesscentre.com

Joan

Training Co-Ordinator
joan@lirbusinesscentre.com

Deirdre

Tutor/Facilitator
deirdre@lirbusinesscentre.com

"I enjoyed the Database L5 module. I did the module fully online. The resources and videos were very beneficial and the Tutor was always available."
Helen Reilly

Office Assistant (2023)

"This could be you ..."
Learner

(2023)

"This could be you ..."
Learner

(2023)

Blended Online Course


€280

  • 'Live' Tutor Online Weekly Scheduled Sessions
  • Lir Upcoming Course Dates
  • Self-directed Learning - Lir eLearning Hub
  • Tutor Online Support
  • Lir Mobile Course App
  • Blended Learning Online
  • Lir Microsoft 365 Software
  • Lir Microsoft Access 365 Software
  • Lir Learner Supports
  • Lir Community Chat
  • CE Participant Rate (Contact Lir Reception 044-934 2754)
  • Or In-Company (Tailor-made Course)


Download Course Brochure

I have read and agree to the terms & conditions.

Other Modules to consider towards the Lir QQI 5M2468 Business Administration Major Award
and other Awards such as the 5M1997 Office Administration Major Award

Business Administration L5

Bookkeeping
 L5

Work
Experience L5

Word
Processing L5

Text
Production L5

Communications
Level 5

Customer
Service L5

Database
Methods L5

Medical
Terminology L5

Information and Administration L5

Intercultural
Studies L5

Digital
Marketing L5

Payroll
 L5

Reception and Frontline Office Skills

Research and Study Skills L5

Spreadsheet
Methods L5

Check our Social Media Platforms for Special Offers and Promotions