Beatsy Solutions Beatsy Solutions
Commercial Digital Literacy General Curriculum Needs_review

Microsoft Access Database Essentials

Learn relational database fundamentals and build a small Microsoft Access database using tables, relationships, queries, forms, and reports....

0.0
(0 ratings)
Category: LMS Training
Created by James Mwangi Last updated 10/2026 English / Swahili
Save up to 72% with a Bundle Deal!
This course is included in Complete Computer Packages All-in-One Career Bundle at a bundled discount.
View Bundle Deals →

What you'll learn

["Design a small relational database and use queries, forms, and reports to manage sample business records."]

Learning Tracks & Pricing Options

Designed for self-paced independent study, with optional 1-on-1 instructor support when needed.

2 Flexible Pathways
Curriculum & Support Feature Option A: Self-Study Ksh 4,000.00 Option B: Assisted Learning Ksh 8,800.00
All 9 Structured Modules
Downloadable PDF Manuals & Starter Code
Hands-on Practical Exercises & Capstone Labs
Verified Certificate of Completion
Dedicated 1-on-1 Instructor Mentorship Add on demand Included
Live Debugging & Screen-Share Support Add on demand Included
Milestone Portfolio Code Reviews Add on demand Included
Enroll Self-Study • Ksh 4,000.00 Enroll Assisted • Ksh 8,800.00
Self-Study Flexibility: If you choose Self-Study, you can request instructor assistance for any specific module whenever you need help without altering your self-study access.

Course Content

9 sections • 858 lessons • 22h total length
Expand all sections

  • What databases are used for
    36min
  • Database, table, record, and field
    36min
  • Explore Access and database objects
    36min
  • Create and save a database
    36min
  • Plan requirements before building
    36min

  • Designing Relational Tables and Enforcing Integrity
    30min

  • Design tables around entities
    36min
  • Choose data types and field properties
    36min
  • Primary keys and unique identifiers
    36min
  • Input masks, defaults, and validation
    36min
  • Enter, edit, and import records
    36min

  • Building Calculated Queries, Input Forms and Reports
    30min

  • Why relationships matter
    36min
  • One-to-many relationships
    36min
  • Primary and foreign keys
    36min
  • Referential integrity
    36min
  • Normalisation and avoidable duplication
    36min

  • Create a select query
    36min
  • Filter using criteria
    36min
  • Sort and calculated fields
    36min
  • Use parameters and multiple criteria
    36min
  • Join related tables in queries
    36min

  • Create forms with a wizard
    36min
  • Arrange controls and labels
    36min
  • Use combo boxes and lookups carefully
    36min
  • Subforms for related records
    36min
  • Validate and test data entry
    36min

  • Create a basic report
    36min
  • Group and summarise records
    36min
  • Sort, format, and control pagination
    36min
  • Use queries as report sources
    36min
  • Export and verify outputs
    36min

  • Backups and compact/repair concepts
    36min
  • Database security and trusted content
    36min
  • Performance and common errors
    36min
  • Document and hand over a database
    36min
  • Capstone: build a small relational database
    36min

Description

Learn relational database fundamentals and build a small Microsoft Access database using tables, relationships, queries, forms, and reports.
Recommended Learning Pathway
Prerequisites / Prior Knowledge:

Basic computer skills; spreadsheet experience helpful

Student Reviews & Feedback

Verified ratings from students enrolled in this course.

No reviews yet for this course. Be the first enrolled student to share feedback!

Chat with us on WhatsApp