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 ratings)
Category: LMS Training
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.
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.
| 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 for36min
-
Database, table, record, and field36min
-
Explore Access and database objects36min
-
Create and save a database36min
-
Plan requirements before building36min
-
Designing Relational Tables and Enforcing Integrity30min
-
Design tables around entities36min
-
Choose data types and field properties36min
-
Primary keys and unique identifiers36min
-
Input masks, defaults, and validation36min
-
Enter, edit, and import records36min
-
Building Calculated Queries, Input Forms and Reports30min
-
Why relationships matter36min
-
One-to-many relationships36min
-
Primary and foreign keys36min
-
Referential integrity36min
-
Normalisation and avoidable duplication36min
-
Create a select query36min
-
Filter using criteria36min
-
Sort and calculated fields36min
-
Use parameters and multiple criteria36min
-
Join related tables in queries36min
-
Create forms with a wizard36min
-
Arrange controls and labels36min
-
Use combo boxes and lookups carefully36min
-
Subforms for related records36min
-
Validate and test data entry36min
-
Create a basic report36min
-
Group and summarise records36min
-
Sort, format, and control pagination36min
-
Use queries as report sources36min
-
Export and verify outputs36min
-
Backups and compact/repair concepts36min
-
Database security and trusted content36min
-
Performance and common errors36min
-
Document and hand over a database36min
-
Capstone: build a small relational database36min
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!