Microsoft Access 2019 – Basic

5(793 Ratings)

Duration

1 Day

Upcoming Batch

14 October 2026

Batch Options

4 hours & 8 hours

Language

English / Arabic

Microsoft Access 2019 – Basic

The MS Access 2019 Basic Course provides a comprehensive introduction to Microsoft Access, focusing on essential concepts for beginners. Participants will learn database design principles, data entry techniques, querying data, creating forms and reports, basic macros, and database security measures. The course is designed to equip individuals with foundational skills in database management, enhancing their productivity and employability.

Key Features Of MS Access 2019 Basic Course

A comprehensive introduction to Microsoft Access 2019 basics
Learn database creation, design, and management
Understand data entry, querying, and reporting
Gain proficiency in forms and user interface customization
Hands-on experience with tables, relationships, and data validation
Practical skills for organizing, sorting, and filtering data
Prepare for advanced Access courses and certifications
Suitable for beginners and those looking to refresh their Access skills

Why Choose CounselTrain for Microsoft Access 2019 Basic Course in Saudi Arabia?

Choosing CounselTrain for the Microsoft Access 2019 Basic Course in Saudi Arabia offers a unique blend of expertise, practical learning, and tailored support. Our experienced instructors guide you through the fundamentals of Access, ensuring a solid understanding of database management. With hands-on exercises and real-world examples, you’ll gain confidence in creating databases, querying data, designing forms and reports, and implementing basic macros. Our flexible learning options accommodate diverse schedules, allowing you to learn at your own pace. Additionally, CounselTrain provides comprehensive course materials, ongoing assistance, and certification upon completion, equipping you with valuable skills for career advancement.

Target Audience

This course is intended for students who have little or no familiarity with Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this course in the 2019 interface.

Course Content

6 modules · 82 topics

01Module 1: Quick Overview of the Access User Interface 17 topics

Access Ribbon
Quick Access Toolbar
Object Navigation Pane
Access Work Surface
Object Overview
Process Overview
Create a Database Using a Wizard
Lab 1: Getting Around the Access Environment
After completing this module, students will be able to:
Understand the organization of the Access ribbon.
Understand context tabs in the ribbon.
Understand the Quick Access Toolbar and how to customize.
Understand the Quick Access Toolbar and how to customize.
Understand the Navigation Pane.
Understand the objects and creation process.
Understand the Access work surface.
Understand how to create databases using a wizard.

02Module 2: Fundamentals 18 topics

Questions to Ask Before You Start
Approaches to Database Design
Gathering Information
A Few Words about Naming Conventions
Normalization
Table Relationships
Lab 1: Fundamentals Exercises:
Asking Questions
Normalizing Data
After completing this module, students will be able to:
Ask questions to consider before you create a database application.
Understand common approaches to database design: top-down and bottom-up.
Go from paperwork and data samples to categorized data (data mapping).
Understand naming conventions for tables and other objects.
Understand what normalization is.
Understand some basic concepts of normalization and how to apply them.
Understand bout primary and foreign keys.
Understand relationships and establishing them among tables.

03Module 3: Tables and Their Views 9 topics

Definition and Purpose
Datasheet View
Design View
Lab 1: Working with Tables in Datasheet View
After completing this module, students will be able to:
Understand tables and table views in Access.
Work with tables in Datasheet view.
Add and Edit data records in Datasheet view.
Understand the purpose of Design view.

04Module 4: Tables14 topics

Creating an Access Database
Data Types
Create a Table in Design View
Lab 1: Tables Exercises:
Creating a New Database
Determining Data Types
Creating a Table in Design View
After completing this module, students will be able to:
Create an Access database.
Create a table in Design view.
Understand data types.
Assign a key field.
Understand input masks.
Use expressions to define validation rules.

05Module 5: Queries 10 topics

Queries
Select Queries
Select Queries with Criteria
Logical Operators
Group and Total with Queries
Lab 1: Creating Select Queries:
Creating Select Queries
After completing this module students will be able to:
Use queries and query views.
Create a simple query.

06Module 6: Forms 14 topics

Forms
Alter a Form
Form Record Navigation
Layout View and Design View
One-click Forms
Form Wizard
Lab 1: Forms Exercises
Adding Data Records in Form View
Creating a Form with the Form Wizard
After completing this module students will be able to:
Understand types of forms.
Add records using a form.
Understand one-click forms.
Create a form using the Form Wizard

Schedule Dates

4 upcoming batches

Session Type

Physical sessions run at our training facility.

Microsoft Access 2019 – Basic
Batch Dates	Duration	Batch Options	Language
14 October 2026Next	1 Day	4 hours & 8 hours	English / Arabic
14 January 2027	1 Day	4 hours & 8 hours	English / Arabic
14 April 2027	1 Day	4 hours & 8 hours	English / Arabic
14 July 2027	1 Day	4 hours & 8 hours	English / Arabic

Can’t find a suitable date? Request a schedule that fits your team.

Request More Information

Access 2019 Basic Course in Saudi Arabia

The MS Access 2019 Basic Course stands out as a pivotal stepping stone for careers in Saudi Arabia due to its unique blend of foundational knowledge and practical skills. Unlike generic database courses, this program is specifically tailored to Saudi Arabia’s business landscape, focusing on database management essentials crucial for local industries. Participants learn database design, data entry, querying, forms, and reports and gain insights into how these skills directly apply to real-world scenarios in Saudi Arabia job market. Moreover, the course is designed to be career-oriented, with modules that emphasize industry-relevant projects and challenges. This ensures that graduates are proficient in Access and equipped to make immediate contributions in Saudi Arabia-based organizations, making it a sought-after credential for those pursuing a career in data management and analysis in Saudi Arabia.

This course includes:

Soft copy of Courseware
Certificate of Course Completion
Experienced and Professional Trainer
Lab and Exercises During Training
Sample Questions for Exam Preparation
Mock Test on the Last Day of Training
Exam Registration Guidance
5-Star Training Environment

Upcoming Batch

14 October 2026

View all batch dates

How We Deliver

Select the method that best suits your needs.

Online Instructor-Led Training Classroom Training Onsite Training Overseas Training

Request More Information

First Name *Please enter your first name.

Last Name

Email Address *Please enter a valid email address.

Phone Number *Please enter your phone number.

Country

Message

Your information is secure and never shared.

How We Deliver

Flexible Training Options to Meet Your Needs

Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.

Select the method that best suits your needs.