SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Microsoft Access Training

Liked the interactive working with other students in the class. This allowed practice of not only the exercise, but what it would be like in a work environment.
Comment from HRSDC

1. Title

  • Microsoft Access Level 2: Macros, Code and Professional Application Development (ACCPRO, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous experience Microsoft Access database design and use

3. Target Audience

  • Business professionals who want to learn how to create powerful relational database applications with Microsoft Access

4. Dates and Pricing

2 People for Guaranteed Live or Virtual Delivery $2,775.00 per person

5. Outline

Module 1: About Microsoft Access

Topic 1: Overview of Application Elements: Tables, Queries, Reports and Macros

Topic 2: Deigning a Microsoft Access Software Solution

Topic 3: About the Separation of Data and Presentation Elements

Topic 4: Creating the Startup Macro

Topic 5: Setting Environment Options

Topic 6: Reading Configuration Values Programmatically

Topic 7: A Note on Application Look and Feel

Topic 8: Exercise: Designing a Microsoft Access Database Solution

Topic 9: Exercise: Creating a Shell for a Microsoft Access Solution

Module 2: Implementing Integrity

Topic 1: About Integrity Types: Domain, Entity and Referential

Topic 2: Review of Normal Forms: From 1st to Boyce-Codd

Topic 3: Handling NULL Values and Empty Values

Topic 4: Implementing Domain Integrity: Default Values, Ranges and Enumerations

Topic 5: Implementing Entity Integrity: Primary Keys

Topic 6: Implementing Referential Integrity: Creating Foreign Keys

Topic 7: Overview of Indexing Guidelines: Performance Guidelines

Topic 8: Creating Indexes in Support of Specific Requirements

Topic 9: Exercise: Designing and Implementing Database Integrity

Topic 10: Exercise: Designing and Implementing Database Indexing

Module 3: Application Programming: The Basics

Topic 1: About Variable Declaration

Topic 2: Understanding Data Types, Variants and their Use

Topic 3: Requiring Variable Declaration

Topic 4: Working with Conditional Statements

Topic 5: Working with Repeating Statements: For Each and Do

Topic 6: Understanding the Difference between a Function and a Procedure

Topic 7: Creating Functions and Procedures

Topic 8: Working with Function and Procedure Parameters: ByRef and ByVal

Topic 9: Exercise: Writing Code Modules in Support of Application Requirements

Module 4: Working with Macros

Topic 1: Macro Basics

Topic 2: About the Macro Editor

Topic 3: Creating Basic Macros

Topic 4: Passing Values to Macros

Topic 5: Manipulating Forms in Macros

Topic 6: Working with Data in Macros

Topic 7: Creating Automation Macros

Topic 8: Exercise: Creating Custom Macros

Module 5: Form Integration

Topic 1: About Microsoft Access Presentation Elements

Topic 2: The Difference between using a Macro and using Code

Topic 3: Calling a Macro from a Form or Report

Topic 4: Common Scenarios: Calling Macros from a Form or Report

Topic 5: Calling Custom Code from a Form or Report

Topic 6: Common Scenarios: Calling Custom Code from a Form or Report

Topic 7: Exercise: Implementing Custom Data Validation

Topic 8: Exercise: Implementing Custom Form Navigation

Module 6: Working with Class Modules

Topic 1: The Difference between a Class Module and a Module

Topic 2: The Need for Objects

Topic 3: Creating a Class Module

Topic 4: Creating Properties

Topic 5: Creating Methods

Topic 6: About Object Initialization and Termination

Topic 7: Using Objects to Implement Custom Behaviours

Topic 8: Using Objects in Form or Report Development

Topic 9: Exercise: Creating Custom Classes for Middle Tier Operations

Module 7: Coding Professionals Forms

Topic 1: Adding Code to Forms

Topic 2: Implementing Custom Form Behaviours

Topic 3: Creating Master – Detail Forms

Topic 4: Loading Default Forms

Topic 5: Controlling the User Experience through Code

Topic 6: Exercise: Creating a Complete User Interface with Microsoft Access

Module 8: Packaging the Application

Topic 1: Separating Presentation and Data

Topic 2: About Packaging the Database Engine

Topic 3: About the Implementation of Configuration Values

Topic 4: Using External DLLs and Packages: Native and .NET

Topic 5: Creating Shortcuts and Support Files

Topic 6: Dealing with Application Pre-Requisites

Topic 7: Creating the MSI File

Topic 8: Testing the Installation

Topic 9: Exercise: Creating an MSI Installation Package

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette