Course Overview
This course provides an introduction to Microsoft Access, focusing on creating and managing databases. Participants will learn how to design database structures, enter and manipulate data, and create reports for information extraction.
Course Objectives
Upon completion of this course, participants will be able to:
- Create and manage Access databases
- Design tables and relationships
- Enter, edit, and update data
- Create queries to retrieve information
- Design forms for data entry and display
- Create reports for data presentation
Course Outline
Module 1: Introduction to Access (2 hours)
- Understanding databases and Access
- Creating and opening databases
- Database objects (tables, queries, forms, reports)
- Navigating the Access interface
Module 2: Database Design (4 hours)
- Creating tables and defining fields
- Data types and field properties
- Primary keys and relationships
- Normalization concepts
Module 3: Data Entry and Manipulation (4 hours)
- Entering data into tables
- Editing and updating records
- Data validation
- Importing and exporting data
Module 4: Queries (4 hours)
- Creating simple and complex queries
- Using query design grid
- Sorting, filtering, and grouping data
- Calculated fields and aggregate functions
Module 5: Forms and Reports (4 hours)
- Creating forms for data entry and display
- Form design and layout
- Creating reports for data presentation
- Report design and formatting
Assessment
- Practical exercises and assignments
- Hands-on projects
Target Audience
This course is suitable for individuals who need to manage and analyze data effectively. It is beneficial for students, professionals, and anyone who requires database skills.
Course Materials
- Microsoft Access software
- Course handouts or digital materials
Note: The duration of each module can be adjusted based on the participants’ learning pace and the depth of coverage desired.
Total Fees: 20,000/=
Total Duration: 20 Hours (2 hours x 10 Classes)
Training Mode: Individual Training, your own timetable
Live Online Classes or Face to Face Direct Classes with our expert trainers.
Call +94 (0) 722000999 / +94 (0) 755123111 www.iss.lk. Medium : සිංහල / தமிழ் / English