Microsoft Access (from beginner to advanced)

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Course Outline:

  1. Introduction to Database Concepts
    • Understanding database management systems (DBMS)
    • Overview of relational databases
    • Introduction to Microsoft Access interface
  2. Database Design
    • Planning and designing a database
    • Creating tables and defining relationships
    • Setting primary keys and enforcing referential integrity
  3. Data Entry and Management
    • Entering data into tables
    • Using forms for data entry and navigation
    • Importing and exporting data
  4. Queries and Data Manipulation
    • Creating basic and advanced queries (select, action, parameter)
    • Using calculated fields and aggregate functions
    • Querying related tables (joins, subqueries)

What Will You Learn?

  • ✅ Introduction to Database Concepts
  • ✅ Database Design
  • ✅ Data Entry and Management
  • ✅ Queries and Data Manipulation
  • ✅ Basics of database design (දත්ත සමුදා නිර්මාණයේ මූලික කරුණු)
  • ✅ Creating and managing tables (වගු සෑදීම සහ කළමනාකරණය කිරීම)
  • ✅ Building powerful queries (විමසුම් ගොඩනැගීම)
  • ✅ Designing professional reports (වෘත්තීය වාර්තා සැලසුම් කිරීම)
  • ✅ Advanced tips and tricks to boost productivity (ඵලදායිතාව ඉහළ නැංවීම සඳහා උසස් ඉඟි සහ උපක්‍රම)

Course Content

Master Microsoft Access – Access from Beginner to Advanced

  • Introduction of DBMS
    11:13
  • How to Start Microsoft Access
    07:35
  • Microsoft Access Data Types
    10:34
  • Microsoft Access-Field Properties
    13:45
  • Primary Key, Foreign Key and Relationships
    14:46
  • How to Create Query Table (Project -1)
    22:09
  • Microsoft Access – (Project -2)
    10:40
  • MS Access – Query, Relationships & Reports
    41:26
  • Microsoft Access – Expression Builder
    26:22
  • How to create a relational database for your library?

PROJECTS and Practical Examination Papers