Training: Access – Advanced functions

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

Description

This course will help you learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

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 courseware 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.
Prix de l'inscription
CHF 1'200.-

jeu20apr(apr 20)09:00ven21(apr 21)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-11

jeu20apr(apr 20)09:00ven21(apr 21)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu01jun09:00ven02(jun 2)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-11

jeu01jun09:00ven02(jun 2)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu13jul(jul 13)09:00ven14(jul 14)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu13jul(jul 13)09:00ven14(jul 14)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-11

jeu17aug(aug 17)09:00ven18(aug 18)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu17aug(aug 17)09:00ven18(aug 18)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-11

jeu21sep(sep 21)09:00ven22(sep 22)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu21sep(sep 21)09:00ven22(sep 22)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-11

jeu26oct(oct 26)09:00ven27(oct 27)17:00VirtuelVirtual Etiquettes de sessionMOA-11

jeu26oct(oct 26)09:00ven27(oct 27)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-11

jeu30novven01decVirtuelVirtual Etiquettes de sessionMOA-11

jeu30novven01decGenève, Route des Jeunes 33B, 1227 Carouge 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