ACCESS BASIC Video Course

Learn how to design and manage relational databases with Access – Learning365® & Mr Key Shop

The Access Basic Video Course, available on Mr Key Shop in collaboration with Learning365®, is the ideal solution for those who want to acquire practical and theoretical skills in relational database management using Microsoft Access. With 29 videos totaling 5 hours and 53 minutes, this course guides you step by step through the creation of tables, queries, forms, and reports, up to the correct use of relationships and referential integrity.

About Learning365®

Learning365® offers structured, vertical training on Microsoft Access, from table design to advanced macros. The courses are divided into freely accessible on-demand modules, with practical examples and business use cases. Users can count on the support of the optional AI Intelligent Tutor, available to answer questions and provide technical insights in real time. The monitoring dashboard allows administrators and trainers to monitor progress, export usage data, and plan professional development activities more effectively.

Objective of the Access Base Course

This course aims to provide comprehensive and accessible training on the design and management of relational databases using Microsoft Access. Upon completion, you will be able to:

• Understand the basics of relational modeling and how Access works
• Create tables, define fields, and set their properties
• Establish relationships between tables and apply referential integrity
• Build complex, parametric, and modification queries
• Create custom forms for data entry and display
• Create reports for analysis and presentation of information

How the Access Basics course is organized

The course is divided into 3 main sections: theoretical and practical lessons, guided exercises, and in-depth analysis. Each video covers a specific topic, with practical examples and exercises to consolidate learning. The contents include:

Lessons

• Overview of Microsoft Access and relational databases
• Creating and configuring tables
• Primary keys and field properties
• Building relationships between tables
• Creating selection and update queries
• Advanced filters and use of the LIKE operator
• Creating forms, reports, and buttons

Practical exercises

• Creating forms on personal data and related tables
• Using parametric queries
• Managing user input with combo boxes
• Designing and structuring a complete form on a customer table

Further information

• Concept and application of referential integrity
• Business simulations on order, customer, employee, and department management
• Construction of aggregate forms and conditional opening of Access objects

Who is this course for?

This course is suitable for:

• Professionals in technical, commercial, or administrative fields
• Staff of companies or public entities that manage data with Access
• Users who want to learn how to build databases in a structured way
• Those who are new to Microsoft Access

Final certificate

Upon completion of the course and passing the final test, you will receive a personal Learning365® certificate, which can be used for professional purposes, inclusion in your CV, or company training reports.

Support

Support is provided by the Learning365® team in English through their official website. Access to the course is via the proprietary platform and purchase is secure, immediate, and customizable for multiple users.

Learning support with the AI Smart Tutor

During the course, you can activate the AI Smart Tutor, an advanced virtual assistant that provides you with contextual and immediate answers to the concepts covered in the modules. Perfect for clarifying doubts or quickly reviewing key content.