Enable Technology

ACCESS PYLE TRAINING COURSES 

ACCESS TRAINING COURSES PYLE




About Enable Technology Pyle Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite socially distanced training location in Pyle. We are happy to modify the Access syllabus to match your teams training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are DHL Express, Wolverhampton City Council, Capita Group PLC, Homeserve PLC, EDF Energy PLC, Birmingham City Council, Loughborough University and Dollond & Aitchison Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Pyle
  • Telephone on 01952 938014
  • 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 ...
  • Working with the Code Editor
    Working with Procedures and Functions
    Working with Methods
    Working with Recordsets
    Understanding the Form Object
    Using Message Boxes
    Working with Boolean Expressions
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Error Handling
    Understanding Objects
    Working with Inline Error Handling
    Setting Break Expressions
    Using the Select Case...End Select Structure
    Declaring Variables
    Why Program in Access?
    Locking Records for Updating
    Understanding Constants
    Determining the Value of Expressions
    Understanding the Err Object

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Pyle
  • 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 ...
  • Sorting and Filtering
    Using a Navigation Form
    Action Queries
    Creating a Relational Database
    Aggregation Queries
    Getting to Know Access 
    Database Wellness
    Creating a Lookup Database
    Creating and Using Macros
    Adding Records to a Table
    Calculations in Queries
    Modifying Table Structures
    Modifying Forms
    DIY Forms
    Macro Techniques
    Setting Table Relationships
    Macros on Forms
    Creating and Using Forms
    Relational Database Design
    Navigation Pane Protection
    Creating Queries

  • See Training Course Details...



Email us about this courses



Other Pyle Enable Technology Training Courses

Oracle SQL Pyle Training Courses
SSRS - Pyle SQL Server Reporting Services Training Courses
Excel Power Pivot Pyle Training Courses
JQuery Pyle Training Courses
JavaScript - Pyle JavaScript Training Courses
Excel 365 Intermediate Pyle Training Courses