Microsoft Access (Levels 1 and 2)

Overview
This course teaches you how to build and manage databases using Microsoft Access, a widely used tool for storing, organizing, and reporting on information. You will learn to design tables, build queries to find and filter the data you need, create forms for easy data entry, and generate reports that present your data clearly. The course moves from foundational database skills through to more advanced, multi-table work across two levels.
The course runs 40 hours combined across both levels and is delivered through practical, hands-on exercises at CIS branches across Lebanon and online.
What You Will Learn
- Navigate the Microsoft Access interface and understand how a relational database is organized
- Create and manage tables, defining fields, data types, and relationships between tables
- Build queries to retrieve, filter, and sort the data you need
- Design forms for efficient and accurate data entry
- Create reports that present data clearly for sharing and decision-making
- Work with queries and relationships across multiple tables
- Apply basic database design principles to keep your data organized and reliable
Course Curriculum
| Module | What you cover |
|---|---|
| Introduction to Microsoft Access | Understanding relational databases and navigating the Access interface |
| Creating and Managing Tables | Defining fields, choosing data types, and setting up relationships between tables |
| Building Queries | Retrieving, filtering, and sorting data to answer real questions |
| Designing Forms | Building user-friendly forms for accurate and efficient data entry |
| Creating Reports | Generating formatted reports to present and share your data |
| Multi-Table Queries and Relationships | Working across multiple related tables to combine and analyze data |
| Database Design Fundamentals | Applying basic design principles to build organized, reliable databases |