Digital, Creative & Business
Microsoft Access
Small database design, queries and reports for office data tracking.
View prospectus
Programme rationale
Small database design, queries and reports for office data tracking. The programme is structured for learners who need practical, assessable capability they can connect to real responsibilities while continuing work or other commitments.
Programme at a glance
Around 4 weeks of guided study, with weekday evening or weekend sessions and short practical tasks between sessions.
| Unit | Study block | Module |
|---|---|---|
| 1 | Week 1 | Database concepts and tables |
| 2 | Week 2 | Queries, forms and reports |
| 3 | Week 3 | Relationships and data integrity |
| 4 | Week 4 | Importing, exporting and basic automation |
Target audience & entry requirements
Target audience
- • Learners, freelancers, entrepreneurs and small-business owners developing practical digital or creative skills.
- • Staff who need stronger digital production, communication or office skills for their current role.
- • School leavers and graduates building an evidence-based portfolio for further study or entry-level opportunities.
Entry requirements
- • Open to all learners; no formal qualification required.
- • Access to a phone, tablet or computer for online and blended study.
- • Commitment to attend sessions and submit assignments on time.
Learning outcomes
By the end of the programme, learners should be able to:
- Design a small relational database
- Build queries, forms and reports
- Maintain clean, linked data
Detailed modules
Each module below follows this programme’s published syllabus and contributes to the final practical work.
- 1
Database concepts and tables
Week 1Examine database concepts and tables as an evidence-to-decision process, from selecting suitable methods to interpreting and presenting findings.
What you cover
- Purpose, scope and ethical considerations for database concepts and tables
- Appropriate data sources, methods and quality checks
- Interpretation, documentation and decision-ready reporting
Assessed work: Produce and review a working analysis or evidence tool for database concepts and tables.
- 2
Queries, forms and reports
Week 2Study queries, forms and reports in the context of digital, Creative & Business, connecting essential concepts with practical decisions and professional documentation.
What you cover
- Essential concepts and terminology within queries, forms and reports
- Methods, tools and professional standards used in practice
- Application through a relevant case, task or workplace scenario
Assessed work: Complete a guided case task applying queries, forms and reports to a realistic setting.
- 3
Relationships and data integrity
Week 3Examine relationships and data integrity as an evidence-to-decision process, from selecting suitable methods to interpreting and presenting findings.
What you cover
- Purpose, scope and ethical considerations for relationships and data integrity
- Appropriate data sources, methods and quality checks
- Interpretation, documentation and decision-ready reporting
Assessed work: Produce and review a working analysis or evidence tool for relationships and data integrity.
- 4
Importing, exporting and basic automation
Week 4Study importing, exporting and basic automation in the context of digital, Creative & Business, connecting essential concepts with practical decisions and professional documentation.
What you cover
- Essential concepts and terminology within importing, exporting and basic automation
- Methods, tools and professional standards used in practice
- Application through a relevant case, task or workplace scenario
Assessed work: Complete a guided case task applying importing, exporting and basic automation to a realistic setting.
Practical project / portfolio
Complete a workplace file using the tool.
Teaching & learning approach
- Tutor-led explanation and demonstration focused on the published module topics.
- Guided practice using cases, scenarios, templates or production tasks relevant to the programme.
- Individual and group feedback that helps learners improve work before final submission.
- Flexible online, face-to-face or blended participation, with evening and weekend scheduling where available.
Assessment & completion
- • Short applied tasks linked to the published modules.
- • Practical component: Complete a workplace file using the tool.
- • A final assessment or portfolio review covering the full syllabus.
- • Participation in guided sessions, discussions and group exercises.
Learner support
- • Session handouts, checklists and templates you keep after the course.
- • Practice files and design or campaign briefs for each tool covered.
- • Tutor guidance by WhatsApp between sessions.
How this programme is delivered
Online
Guided sessions and assignments you can follow from anywhere with a connection.
Face-to-face
Classroom sessions at our Mile 91 learning centre, including weekend and evening options.
Blended
A mix of online study with periodic in-person workshops, field exercises and simulations.
Career & professional pathways
This programme supports professional development; it does not guarantee employment, promotion or entry to a regulated occupation.
- Use the completed portfolio to demonstrate practical capability for freelance, small-business or junior digital work.
- Apply the skills within communications, administration, marketing or programme-support responsibilities.
- Progress to a longer SLIHSD digital, creative or business programme where available.
Fees & enrolment
- • Indicative programme fee: SLE 150.
- • One-off indicative registration fee: SLE 100.
- • Final fees, start date, delivery arrangement and any instalment option are confirmed in writing before commitment.
- • Submitting an application does not require payment and does not guarantee admission.
Regulatory & recognition notice
SLIHSD is a developing professional learning institution. Accreditation and formal recognition are subject to applicable regulatory approvals. Completion records an SLIHSD professional short course and is not presented as an accredited academic award.
Learners who complete all assessments receive an SLIHSD professional certificate of completion. This records completion of an SLIHSD short course and is not presented as an accredited academic award.
Ready to start Microsoft Access?
Applications for the Founding Student Intake 2026 are open. Register your interest and we will guide you to the right programme.