Microsoft Access Course & Training | NADIA Training Institute

WHO IS MICROSOFT ACCESS COURSE FOR?

The MS Access training is designed for individuals who are used to managing data in spreadsheets but wish to understand why and how a database will provide a better solution. The training takes the participants through the process of creating a database, from design through to data population.

WHAT WILL I LEARN?

Introduction

Using Microsoft Access
Overview of MS Access
Basic Concepts
What is a Database?
Relational Database

Database Objects
Getting Started with Microsoft Access 2010
Open a new blank database
Create a new database from a featured template

Creating Database and Tables

MS Access Screen
The Access Environment
The navigation Pane
The Ribbon
Designing a Database
The Basic steps in designing a database
Designing Tables

Working with Tables
Creating Calculated Field in Access
Primary Key
Using the Lookup wizard
Entering a Field Description
Assigning a Field Properties

Table Relationships

Working with Table Relationship
How Relationship Work?
Setting up a relationship?
Enforce Referential Integrity

Types of Relationships
Modifying an Existing Relationship
Deleting an Existing Relationship

Microsoft Access Forms

Forms
Anatomy of a form
Create Simple Form
Control Command Buttons
Database application Form in MS Access

Microsoft Access Queries

Introduction
List of Operators and their meaning in Microsoft Access Query
Creating a Microsoft Access Query from Scratch
Creating Query with Criteria
Action Queries

Update Queries
Delete Queries
Parameter Queries
Crosstab query

Microsoft Access Reports

Reports
Creating a Report
Creating Report Microsoft Access using Report Wizard
Building Microsoft Access Report using “Report Design”

Anatomy of Microsoft Access Report
Creating Calculated Fields in a Report
Using Conditional Formatting in Access Reports

Microsoft Access Database Application

Database Applications
What is a Microsoft Access Application?
Creating an application with Database Wizard
To create application with Database Wizards (Templates)
Designing a Startup Form
Password Protect Access Database (Encrypt/Decrypt)

Microsoft Access Advanced Techniques

Macros
Creating a Macro in Microsoft Access
Working with Form Properties window
Completing the Main Menu Window
Creating a Start-up Form “Main Menu”
Adding a Macro to a Command Button in Access

Printing in Microsoft Access

Overview of Printing
Print Preview Screen
Print Preview Ribbon
Printing Options for Specific Objects

Introduction

Using Microsoft Access
Overview of MS Access
Basic Concepts
What is a Database?
Relational Database
Database Objects
Getting Started with Microsoft Access 2010
Open a new blank database
Create a new database from a featured template

Creating Database and Tables

MS Access Screen
The Access Environment
The navigation Pane
The Ribbon
Designing a Database
The Basic steps in designing a database
Designing Tables
Working with Tables
Creating Calculated Field in Access
Primary Key
Using the Lookup wizard
Entering a Field Description
Assigning a Field Properties

Table Relationships

Working with Table Relationship
How Relationship Work?
Setting up a relationship?
Enforce Referential Integrity
Types of Relationships
Modifying an Existing Relationship
Deleting an Existing Relationship

Microsoft Access Forms

Forms
Anatomy of a form
Create Simple Form
Control Command Buttons
Database application Form in MS Access

Microsoft Access Queries

Introduction
List of Operators and their meaning in Microsoft Access Query
Creating a Microsoft Access Query from Scratch
Creating Query with Criteria
Action Queries
Update Queries
Delete Queries
Parameter Queries
Crosstab query

Microsoft Access Reports

Reports
Creating a Report
Creating Report Microsoft Access using Report Wizard
Building Microsoft Access Report using “Report Design”
Anatomy of Microsoft Access Report
Creating Calculated Fields in a Report
Using Conditional Formatting in Access Reports

Microsoft Access Database Application

Database Applications
What is a Microsoft Access Application?
Creating an application with Database Wizard
To create application with Database Wizards (Templates)
Designing a Startup Form
Password Protect Access Database (Encrypt/Decrypt)

Microsoft Access Advanced Techniques

Macros
Creating a Macro in Microsoft Access
Working with Form Properties window
Completing the Main Menu Window
Creating a Start-up Form “Main Menu”
Adding a Macro to a Command Button in Access

Printing in Microsoft Access

Overview of Printing
Print Preview Screen
Print Preview Ribbon
Printing Options for Specific Objects

JOIN 1000'S OF PROFESSIONALS

I really enjoyed the training and felt so comfortable during that period. The instructor’s style was very effective by explaining every subject and giving examples for each one. I really recommend my friends to come and participate in courses here

Zana Namiq

NADIA Training Alumni
Today I completed online Personality Development training conducted by Mr Tinu Thomas. The sessions were very informative, inspiring and interesting. He gave real life like examples which helped me understand the concepts clearly. My confidence level improved and I hope this course would help me pursue my future career in a better way. Thank you so much, Tinu.

GS Meera

NADIA Training Alumni
I just completed my training at Nadia with the trainer (Tinu Thomas). Tinu made the classes so interesting and he gave attention to each student. Classes were very informative. I will definitely recommend to my friends. 🙂 Mariska was so helpful throughout the course for any assistance. Thank you so much to team Nadia!

Sherin Kabeer

NADIA Training Alumni
I did my PHRM training with Mr. Tinu from Nadia and it was a fruitful learning experience for me. Mr. Tinu is a great trainer and he gives attention to each student in his class. He always ensures that each student understand every concept. I'm so glad that I chose Nadia and had the chance to learn from the best. Looking forward to do more professional trainings with Mr. Tinu.. Thank you Mr. Tinu and Nadia !!

Hashini K

NADIA Training Alumni

Frequently Asked Questions

What are the benefits of registering for a course at NADIA?

NADIA Training Institute has been the benchmark for professional training in the Gulf market for more than 38 years. We have built thousands of careers and developed skill sets with our world-class training courses. Whether you want to enhance your job prospects or increase your productivity at work, you will find suitable courses at NADIA.