Enable Technology



Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Understanding the DoCmd Object
    Using Intrinsic Constants
    Working with Variable Scope
    Handling Errors
    Working with Recordsets
    Understanding Recordset Cursor Properties - Optional
    Using the CacheSize Property - Optional
    Specifying a Recordset Cursor Location - Optional
    Using Break Mode during Run Mode
    Working with the Code Editor
    Understanding Collections
    Using the Immediate Window to Call Procedures
    Using Debugging Tools
    Guidelines for use of Branching Structures
    Declaring Variables
    Working with Boolean Expressions
    Creating a Sub Procedure
    Using the Select Case...End Select Structure
    Controlling Program Execution

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Adding Records to a Table
    Creating a Lookup Database
    Calculations in Queries
    Database Security
    Modifying Forms
    Creating and Using Reports
    Modifying Table Structures
    DIY Forms
    An Introduction to VBA
    Database Wellness
    Creating and Using Macros
    Setting Table Relationships
    Relational Database Design
    Macro Techniques
    Formatting Tables
    Parameter Queries
    Getting to Know Access 
    Data Validation
    Importing and Exporting Records
    Querying Techniques
    Macros on Forms

  • See Training Course Details...

Email us about this courses

Other Uk Enable Technology Training Courses

Data Warehouse Uk Training Courses
SSIS 2014 Uk Training Courses
Excel Basic Uk Training Courses
Oracle BI Uk Training Courses
PHP Uk Training Courses
SSAS 2014 Uk Training Courses