Formation en classe ou virtuelle et en direct
The course Macros, Code & Automation (Microsoft Access Training) builds upon the course Tables, Queries & More by showing you how to data access forms and associates data access code with MS Access. Participants learn how to build forms, develop macros and write supporting code. You will learn how to build data drive applications using MS Access. The 50:50 theory to practice ratio help you learn how to build real applications using MS Access
2 personnes pour un cours sur mesure
$3,750.00
About Microsoft Access
Overview of Application Elements: Tables, Queries, Reports and Macros
Deigning a Microsoft Access Software Solution
About the Separation of Data and Presentation Elements
Creating the Startup Macro
Setting Environment Options
Reading Configuration Values Programmatically
A Note on Application Look and Feel
Exercise: Designing a Microsoft Access Database Solution
Exercise: Creating a Shell for a Microsoft Access Solution
Implementing Integrity
About Integrity Types: Domain, Entity and Referential
Review of Normal Forms: From 1st to Boyce-Codd
Handling NULL Values and Empty Values
Implementing Domain Integrity: Default Values, Ranges and Enumerations
Implementing Entity Integrity: Primary Keys
Implementing Referential Integrity: Creating Foreign Keys
Overview of Indexing Guidelines: Performance Guidelines
Creating Indexes in Support of Specific Requirements
Exercise: Designing and Implementing Database Integrity
Exercise: Designing and Implementing Database Indexing
Application Programming: The Basics
About Variable Declaration
Understanding Data Types, Variants and their Use
Requiring Variable Declaration
Working with Conditional Statements
Working with Repeating Statements: For Each and Do
Understanding the Difference between a Function and a Procedure
Creating Functions and Procedures
Working with Function and Procedure Parameters: ByRef and ByVal
Exercise: Writing Code Modules in Support of Application Requirements
Working with Macros
Macro Basics
About the Macro Editor
Creating Basic Macros
Passing Values to Macros
Manipulating Forms in Macros
Working with Data in Macros
Creating Automation Macros
Exercise: Creating Custom Macros
Form Integration
About Microsoft Access Presentation Elements
The Difference between using a Macro and using Code
Calling a Macro from a Form or Report
Common Scenarios: Calling Macros from a Form or Report
Calling Custom Code from a Form or Report
Common Scenarios: Calling Custom Code from a Form or Report
Exercise: Implementing Custom Data Validation
Exercise: Implementing Custom Form Navigation
Working with Class Modules
The Difference between a Class Module and a Module
The Need for Objects
Creating a Class Module
Creating Properties
Creating Methods
About Object Initialization and Termination
Using Objects to Implement Custom Behaviours
Using Objects in Form or Report Development
Exercise: Creating Custom Classes for Middle Tier Operations
Coding Professionals Forms
Adding Code to Forms
Implementing Custom Form Behaviours
Creating Master – Detail Forms
Loading Default Forms
Controlling the User Experience through Code
Exercise: Creating a Complete User Interface with Microsoft Access
Packaging the Application
Separating Presentation and Data
About Packaging the Database Engine
About the Implementation of Configuration Values
Using External DLLs and Packages: Native and .NET
Creating Shortcuts and Support Files
Dealing with Application Pre-Requisites
Creating the MSI File
Testing the Installation
Exercise: Creating an MSI Installation Package
Formation Microsoft Access: Macros, code et automatisation
Le cours Formation Microsoft Access : Macros, code et automatisation s'appuie sur le cours Tables, requêtes et plus en vous montrant comment accéder aux données des formulaires et associer le code d'accès aux données avec MS Access. Les participants apprennent à créer des formulaires, à développer des macros et à écrire du code de soutien. Vous apprendrez à créer des applications d'accès aux données à l'aide de MS Access. Le rapport théorie/pratique de 50/50 vous permet d'apprendre à créer des applications réelles à l'aide de MS Access.
Formations intitulées Formation Microsoft Access: Macros, code et automatisation qui vous permttront d'avancer votre carrière.
Contactez-nous pour des dates$3,750.00
Formation Microsoft Access: Tableaux, requêtes et autres
Le cours Formation Microsoft Access : Tableaux, requêtes et autres fournit une introduction solide à la création de tables et à l'écriture de requêtes SQL. Les participants apprennent à définir les colonnes des tableaux à l'aide des types de données et des règles de validation standard d'Access. Des tables de données normalisées sont créées et ciblées à l'aide de tous les types de requêtes MS Access disponibles. Le rapport 50:50 entre la théorie et la pratique vous aide à comprendre comment concevoir et mettre en œuvre des modèles de données à l'aide de MS Access.
Formations intitulées Formation Microsoft Access: Tableaux, requêtes et autres qui vous permttront d'avancer votre carrière.
Contactez-nous pour des dates$2,750.00
Contactez-nous pour des dates$2,750.00
Contactez-nous pour des dates$3,750.00