Microsoft Access - advanced level

Objectives - at the end of the course the participants will be able to

• create a database application
• use advanced SQL query elements
• create customized forms and reports

Target audience:

Personnel from production or service companies, involved in analysis and reporting - departments: quality, production, logistics, human resources, financial, etc.

Duration: 3 days

Agenda:

• Introduction
• Database analysis and design
• Validation rules. Advanced queries
• Forms - use Developer. Reports and subreports
• Making an application
• Discussions. Examination. Closing the course

Presented tools:

Data integrity, Validation rules, SQL commands, Designer and Developer, Reports and subreports - use of groups and aggregate functions

Full practical course. Requires own computer with Microsoft Office 2016/2019/2021.

Trainer:

He is certified as a Microsoft Certified Trainer (MCT) and has over 20 years of experience in professional training, consulting, and teaching activities in information technology.

For more information, please contact us.