Enable Technology



Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Using Break Mode during Run Mode
    Using the CacheSize Property - Optional
    Guidelines for use of Branching Structures
    Working with Events
    Handling Errors
    Understanding Objects
    Creating a Sub Procedure
    Controlling Program Execution
    Using the Object Browser
    Debugging Code
    Understanding Recordset Cursor Properties - Optional
    Understanding Control-of-Flow Structures
    Understanding the Form Object
    Specifying a Recordset Cursor Type
    Locking Records for Updating
    Writing an Error-Handling Routine
    Declaring Variables
    Determining the Value of Expressions
    Understanding the DoCmd Object
    Stepping through Code
    Working with Inline Error Handling

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Understanding VBA
    Modifying Forms
    Navigation Pane Protection
    An Introduction to VBA
    Calculations in Queries
    Creating a Lookup Database
    Adding Records to a Table
    DIY Forms
    Using a Navigation Form
    Data Validation
    Multi Table Queries
    Action Queries
    Database Wellness
    Creating and Using Forms
    Sorting and Filtering
    Parameter Queries
    Importing and Exporting Records
    Modifying Table Structures
    Formatting Tables
    Creating and Using Macros
    Creating Queries

  • See Training Course Details...

Email us about this courses

Other Uk Enable Technology Training Courses

Data Warehouse Uk Training Courses
Excel 365 Basic Uk Training Courses
Excel Power Pivot - Uk Excel Training Courses
Oracle SQL Uk Training Courses
PL/SQL Uk Training Courses
Power BI Uk Training Courses