Enable Technology

ACCESS AMMANFORD TRAINING COURSES 

ACCESS TRAINING COURSES AMMANFORD




About Enable Technology Ammanford Access Training Courses

We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with Access training materials which they keep after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We are set up to deliver Access training courses onsite at your premises. If delivery onsite is an issue we will organise a socially distanced venue near you in Ammanford. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Aston University, West Bromwich Building Society, GKN PLC, Capita Group PLC, Lloyds TSB Bank PLC, Shell UK Oil Products Ltd, Royal & Sun Alliance Group PLC and Keele University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ammanford
  • 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 ...
  • Setting Breakpoints
    Understanding VBA's Error Trapping Options
    Creating a Standard Module
    Working with the Code Editor
    Using the CacheSize Property - Optional
    Working with Procedures and Functions
    Understanding the Err Object
    Using Intrinsic Constants
    Understanding Expressions and Statements
    Stepping through Code
    Understanding Objects
    Working with the Application Object
    Calling Procedures
    Introduction to Programming in Access
    Debugging Code
    Organizing Code and Procedures
    Specifying a Recordset Cursor Location - Optional
    Using Debugging Tools
    Declaring and Creating Object Variables
    Understanding the Order of Events

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Ammanford
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Importing and Exporting Records
    Macros on Forms
    Using a Navigation Form
    Querying Techniques
    Sorting and Filtering
    Multi Table Queries
    DIY Forms
    Designing a Lookup Database
    Macro Techniques
    Creating and Using Macros
    Modifying Forms
    Understanding VBA
    Modifying Table Structures
    Creating a Relational Database
    Setting Table Relationships
    Data Validation
    Navigation Pane Protection
    Creating a Lookup Database
    Database Wellness
    Getting to Know Access 
    Aggregation Queries

  • See Training Course Details...



Email us about this courses



Other Ammanford Enable Technology Training Courses

Excel 365 Advanced - Ammanford Excel Training Courses
SSRS Ammanford Training Courses
Excel 365 Intermediate - Ammanford Excel Training Courses
SSAS Tabular - Ammanford SQL Server Analysis Services Training Courses
Oracle SQL Ammanford Training Courses
JQuery Mobile Ammanford Training Courses