This is an example of a simple banner
☀️ It's summer at ITTA! Enjoy a 10% discount until July 31st on a selection of courses 🌴 ×

Training: Access – Advanced

Ref. MOA-11
Duration:
2
 days
Exam:
Not certifying
Level:
Advanced

Description

This course is designed to provide participants with in-depth knowledge of the advanced features of Microsoft Access software. Access is a relational database management system widely used for creating, manipulating and analysing data.

During this training, participants will learn how to exploit the advanced features of Access to effectively manage large amounts of data, automate complex tasks and optimise the performance of their databases.

Participant profiles

  • Database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills

Objectives

  • Customize a form layout to improve usability and efficiency of data entry
  • Share data across applications
  • Use macros to improve user interface design
  • Use VBA to enhance tasks
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy
  • Lock down and prepare a database for distribution to multiple users
  • Create and modify a database switchboard and set the startup options

Prerequisites

  • Experience working with Microsoft Access
  • Working knowledge of database design and creation, form design and creation, report design and creation
  • Working knowledge of database querying and the various table relationships

Course content

Module 1: Implementing Advanced Form Design

  • Lesson 1: Add Controls to Forms
  • Lesson 2: Enhance Navigation and Organization of Forms
  • Lesson 3: Apply Conditional Formatting

Module 2: Sharing Data Across Applications

  • Lesson 1: Import Data into Access
  • Lesson 2: Export Access Data
  • Lesson 3: Link Tables to External Data Sources
  • Lesson 4:Create a Mail Merge

Module 3: Using Macros to Improve User Interface Design

  • Lesson 1: Create a Macro
  • Lesson 2: Restrict Records Using a Condition
  • Lesson 3: Validate Data Using a Macro
  • Lesson 4: Automate Data Entry Using a Macro

Module 4: Using VBA

  • Lesson 1: Getting Started with VBA
  • Lesson 2: Enhance Access Using VBA

Module 5: Using Advanced Database Management

  • Lesson 1: Manage a Database
  • Lesson 2: Determine Object Dependency
  • Lesson 3: Document a Database

Module 6: Distributing and Securing a Database

  • Lesson 1: Splitting a Database for Multiple User Access
  • Lesson 2: Implement Security
  • Lesson 3: Convert an Access Database to an ACCDE File
  • Lesson 4: Package a Database with a Digital Signature

Module 7: Managing Switchboards

  • Lesson 1: Create a Database Switchboard
  • Lesson 2: Modify a Database Switchboard
  • Lesson 3: Set Startup Options

Documentation

  • Digital course material included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

Prix de l'inscription
CHF 1'200.-
Inclus dans ce cours
  • Training provided by an expert trainer
  • Documentation in digital format
  • Achievement Badge

lun29juil(juil 29)09:00mar30(juil 30)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-11

lun29juil(juil 29)09:00mar30(juil 30)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu01Aoû09:00ven02(Aoû 2)17:00VirtuelAnnuléeVirtual Etiquettes de sessionMOA-11

jeu01Aoû09:00ven02(Aoû 2)17:00Lausanne, Avenue Mon repos 24, 1005 LausanneAnnulée Etiquettes de sessionMOA-11

jeu05Sep(Sep 5)09:00ven06(Sep 6)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu05Sep(Sep 5)09:00ven06(Sep 6)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-11

jeu10Oct(Oct 10)09:00ven11(Oct 11)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu10Oct(Oct 10)09:00ven11(Oct 11)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-11

jeu14Nov(Nov 14)09:00ven15(Nov 15)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu14Nov(Nov 14)09:00ven15(Nov 15)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-11

jeu19Déc(Déc 19)09:00ven20(Déc 20)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu19Déc(Déc 19)09:00ven20(Déc 20)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-11

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X