Developing relational databases with ACCESS (TOSA certification)

Deepen the notions of querying and exploiting a database and validate the TOSA certification.

This certification offers more complex learning linked to the progression of levels broken down into three skill areas:

• Operational (TOSA from 551 to 725 points), Advanced (TOSA from 726 to 875 points), or Expert (TOSA from 876 to 1000 points) levels give access to certification

• Initial level (TOSA from 1 to 350 points) and Basic level (TOSA from 351 to 550 points ), give rise to a certificate of prior learning at the end of the course.

3 skill areas:

Tables & Queries

• Initial level: Opening a table, entering and sorting data.

• Basic level: Understanding databases (tables, fields, records), distinguishing between Creation/Datasheet modes, entering data, creating simple queries.

• Operational level: Creating simple tables, fields and relationships, sorting/filtering, selection and action queries.

• Advanced level: Creating a database from scratch, importing Excel data, managing advanced fields (masks, compound primary keys), complex queries with joins and SQL.

• Expert level: Mastering multi-source import/export, separating bases (front/back), creating complex queries, pivot tables, advanced SQL.

Forms & Reports

• Initial level: Opening a form, entering data, printing a report.

• Basic level: Displaying, modifying data, navigating between records.

• Operational level: Creating simple forms with or without a wizard, customising the display and controls, adding graphic objects, modifying the layout (Creation , page).

• Advanced level : Create elaborate forms with graphic tools, dual display, all types of controls, advanced customisation.

• Expert level : Complete mastery of controls, SQL statements in forms, report groupings, advanced statistical calculations.

Macros & VBA

• Initial level : Using ready-made macros or VBA modules.

• Basic level : Identifying macros and the role of VBA.

• Operational level: Create simple macros, insert buttons, read/modify basic code, display the VBA environment (VBE).

Advanced level: Create simple VBA macros and procedures, recognise syntax concepts, use arithmetic operators and With/End With blocks, conditions, loops, manage triggers and custom menus.

• Expert level : Mastery of VBA, use of all types of variables, events, debugging tools, dialogue boxes, independent forms, conditional actions via macros.

• TOSA certification

More information about this certification (RS7096, exact wording of the diploma, name of the certifier, date of registration of the certification) by clicking here.

• All audiences

Be proficient in the functions of basic office software, more specifically Excel, and use the Access 2019 version

• Fully classroom-based training

• Group lessons

• Room equipped with networked computer workstations

EN-certified teachers, Bac +3 trainers with significant experience in adult education, professional lecturers

Apply the techniques taught in training to your professional assignments.

Acquire additional skills by taking a training course to achieve TOSA certification

Access for people with disabilities

Transport

behind the police station
near the village hall and bowling alley

This course is accessible all distance, hybrid or face-to-face.

The ENI platform, at everyone's pace, offers training materials and application exercises that follow the learning progress and TOSA certification objectives.

Modular and adaptive tests for improved positioning.

- A combined consideration of starting level and "business" objectives.

- Regular and accurate progress statements.

- Certification adding to the employability of trainees at the end of the course.

- The possibility of taking the decision to follow this training yourself, thanks to the Personal Training Account.