Advanced Microsoft Access 365 (MACC365)

Global Knowledge Network Netherlands bv

This course helps organizations improve data accuracy, streamline workflows, and expand the capabilities of their existing Access solutions.Participants will learn advanced techniques for working

Prijs
vanaf € 1.450
Niveau
Niet opgegeven
Soort
Opleiding
Thema
Automatisering en ICT

Meer informatie en aanmelden bij Global Knowledge Network Netherlands bv

Beschrijving

This course helps organizations improve data accuracy, streamline workflows, and expand the capabilities of their existing Access solutions.Participants will learn advanced techniques for working with relationships, queries, forms, and reports, as well as how to import, link, and export data from external sources. The course also introduces macros and navigation forms to help automate tasks and create complete desktop database applications. By the end of the course, learners will be able to optimize databases, improve usability, and deliver more polished, professional Access applications. Updated July 2026 1- RelationshipsReviewReferential IntegrityRelationshipsA Few Words about Naming ConventionsCreating Relationships (Exercise)2- Advanced QueriesQuery Design ViewReview of Select QueriesReview of Select Queries with CriteriaLogical OperatorsParameter QueriesAction QueriesCreating Select and Action Queries (Exercise)Creating a Parameter Query (Exercise)3- Table FunctionsImporting DataLinking Tables from External SourcesImport Tables from other DatabasesTables from Templates and Application PartsImporting Data from Excel

Startmomenten

Start Einde Plaats Prijs
7 januari 2027 8 januari 2027 Online € 1.450
4 maart 2027 5 maart 2027 Online € 1.450
6 mei 2027 7 mei 2027 Online € 1.450
1 juli 2027 2 juli 2027 Online € 1.450
2 september 2027 3 september 2027 Online € 1.450
4 november 2027 5 november 2027 Online € 1.450