The Database Management sub-domain covers our Microsoft Access training for executive assistants, secretaries, project managers, management controllers and officers wishing to structure a business database. Our catalogue covers Access Fundamentals and Access Advanced. Whether you start with Access or wish to gain autonomy on more complex databases, you will find the training matching your level, delivered in Geneva, Lausanne or virtual classroom by trainers active in advanced office automation.
FILTER BY
- Domains
- Editors
- Location
- Format
- Level
- Certifying
- Confirmed training
Access training in Geneva and Lausanne. 1 day to master Microsoft Access, databases and queries at ITTA Switzerland.
Master Microsoft Access with this advanced training. Manage databases, forms, and secure and optimize your data.
Microsoft Access remains, in 2026, a relevant tool to quickly structure a business database in an SME, service or department, complementing Excel spreadsheet. Customer follow-up, stock management, prospect database, contract register, registration management, quality follow-up: Access enables a non-developer profile to produce a structured management application with forms, queries and reports, without resorting to classic development. In Geneva, Lausanne and across French-speaking Switzerland, private banks, international organisations, administrative services, SMEs and associations still widely use Access for specific internal usages.
Following a recognised Access training opens access to skills valued in support and back-office functions: executive assistants, secretaries, project managers, management controllers, quality officers, HR. These skills are particularly expected in organisations maintaining historical Access bases or wishing to structure business follow-up without investing in specific development. Access mastery is a natural complement to Excel for profiles exceeding spreadsheet limits.
ITTA offers a catalogue dedicated to Access, from Fundamentals level to Advanced level. Each session is built around practical cases inspired by the daily work of Swiss organisations, with limited group sizes to enable personalised support and individual feedback on your own databases.
Whether you are an executive assistant, management controller, project manager, quality officer, HR or advanced Excel user wishing to move to Access, our training in Geneva and Lausanne provides the practical skills to model your database, create your forms and reports, and sustainably reliably your business follow-up.
The Access Fundamentals training lays the basics of the software and the relational model applied to office databases. The programme covers the interface, table and relationship creation, field types, primary keys, simple queries (selection, update, append, delete), data entry forms, print reports and structuring best practices. This training suits profiles discovering Access or wishing to revisit basics before moving to more advanced usage.
The Access Advanced training deepens the productive features that transform Access from an enhanced spreadsheet tool into a true management application. The programme addresses complex queries (cross-tab, parameterised, action), clean relational modelling, sub-forms, advanced reports with groupings, macros to automate actions, and an introduction to VBA for users wishing to customise further. This training suits confirmed Access profiles driving a business database or maintaining an existing Access application.
A newcomer to Access follows Access Fundamentals to acquire relational model basics and current tool usage. An advanced Excel user wishing to manage more structured data progresses to Access Advanced after Fundamentals to fully leverage complex queries and automation. An executive assistant or management controller maintaining an existing Access database combines both levels to gain autonomy. For profiles sustainably exceeding Access needs and targeting a true multi-user application, the data analysis and databases sub-domain brings SQL Server and Azure SQL to scale.
Here is a selection of reference training courses in this catalogue, accessible directly:
Access fits into a broader office automation and data ecosystem. Office automation training brings an overview of Office 365 (Word, Excel, PowerPoint, Outlook). The Excel spreadsheet sub-domain is complementary, particularly for profiles combining Excel for analysis and Access for data persistence. Data analysis BI training brings Power BI for visualising data from Access. On the evolution side towards a more powerful database, the data analysis and databases sub-domain covers SQL Server and Azure SQL, and the database design sub-domain deepens SQL and NoSQL on the development side. The no-code development domain brings Microsoft Power Platform (Power Apps, Power Automate, Dataverse) for profiles wishing to scale Access.
Several evolutions are shaping Access usage in 2026. Microsoft now positions Power Apps and Dataverse as the evolution of historical Access usages for new applications, which makes Power Platform mastery particularly useful for evolving Access profiles. Access nonetheless remains maintained in Microsoft 365 and continues to be used in organisations with productive historical databases. Copilot features are progressively entering Access queries, which simplifies SQL query writing and data analysis. Our pedagogical content regularly integrates these evolutions to remain aligned with current company practices.
All our Access training courses are available on-site in our Geneva (Route des Jeunes 35) and Lausanne (Avenue de Mon-Repos 24) centres, as well as in interactive virtual classroom with a live trainer. Our sessions are organised in 5-week cycles, which makes registration fast and planning smooth for working support profiles. Each session includes hands-on exercises on concrete cases and the possibility to work on your own databases. Customised corporate training is also possible at your premises, in Geneva, Lausanne, Vaud and across French-speaking Switzerland, with a programme adapted to your internal use cases. Several professional funding paths can be considered depending on your profile and employer.
ITTA is a certified training centre based in French-speaking Switzerland, official partner of Microsoft Office and Microsoft. Our Access trainers are professionals active in support, management control or office automation consulting roles, allowing them to share proven templates and best practices directly usable on your own databases. The Access catalogue regroups our training courses covering Fundamentals and Advanced. Our pedagogical team supports you in choosing the right path and identifying the funding solutions that fit your professional situation.
Is Excel experience required before Access Fundamentals?
Good Excel practice facilitates Access onboarding (notions of table, sort, filter, formula). Access Fundamentals nonetheless remains accessible to profiles without deep Excel experience, provided they have good general IT ease.
Is Access still useful in 2026 facing Power Platform?
Access remains relevant for historical usages (existing databases, specific internal applications) and for non-developer profiles wishing to stay on a classic office tool. Power Platform (Power Apps, Power Automate, Dataverse) constitutes the natural evolution for new applications and industrialisation. Both tools frequently coexist in the same organisation.
What is the difference between Access and SQL Server?
Access is a single-user or lightweight multi-user office DBMS, integrated into Microsoft 365. SQL Server is a robust enterprise multi-user DBMS, supporting significant loads and distributed architectures. Access suits SMEs and services structuring internal follow-up, SQL Server suits enterprise applications. Our pedagogical team guides you on the possible evolution of an Access database to SQL Server.
Are your Access courses available for companies?
Yes, the entire Access catalogue is available in-house, in Geneva, Lausanne and in virtual classroom, with a programme adapted to your internal use cases. Our team builds the specifications with you and organises sessions according to your calendar.
Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00
ITTA
Route des jeunes 35
1227 Carouge, Suisse
Monday to Friday, from 8:30 am to 06:00 pm.
