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

Microsoft Access Training


I am enjoying the ability to control the guide and therefore streamline my queries... beyond that the classroom is set up well, the instructor does a good job of identifying weaknesses in understanding and elaborating further.
Comment from Askari Solutions

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